SELECT
    EMP_CODE,
    replace(EMP_NAME," ","") AS EMP_NAME
FROM
    TBL_EMPLOYEES
ORDER BY
    EMP_CODE desc;