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