select e.EMP_CODE as CODE, e.EMP_LAST_NAME as SURNAME, e.EMP_FIRST_NAME as NAME
from EMP e
where e.VALID_FLG = '1'
order by replace(SURNAME,' ',''), replace(NAME,' ',''), CODE;