SELECT 
  EMP_CODE AS CODE,
  EMP_LAST_NAME AS SURNAME,
  EMP_FIRST_NAME AS NAME
FROM 
  EMP
WHERE 
  VALID_FLG = '1'
ORDER BY
  REPLACE(EMP_LAST_NAME,' ','') ASC,
  EMP_CODE ASC;