select 
    EMP_CODE
    ,replace(EMP_NAME," ","") as "EMP_NAME"
from
    TBL_EMPLOYEES
order by
    EMP_CODE desc;