select 
 a.EMP_CODE       as CODE
,a.EMP_LAST_NAME  as SURNAME
,a.EMP_FIRST_NAME as NAME
from
  emp a
where
    a.VALID_FLG = '1'
and REPLACE(a.EMP_LAST_NAME,' ','')||REPLACE(a.EMP_FIRST_NAME,' ','') = REPLACE(a.EMP_LAST_NAME,' ','')||REPLACE(a.EMP_FIRST_NAME,' ','')
order by
  REPLACE(a.EMP_LAST_NAME,' ','')||REPLACE(a.EMP_FIRST_NAME,' ','')
  , a.EMP_CODE