SELECT
EMP_CODE AS CODE,
EMP_LAST_NAME AS SURNAME,
EMP_FIRST_NAME AS NAME

FROM EMP
 
TRIM(' ' FROM EMP_LAST_NAME)
TRIM(' ' FROM EMP_FIRST_NAME)
WHERE 

VALID_FLG ＝ '1'

ORDER BY

EMP_CODE ASC;