select
EMP_CODE as CODE,
(EMP_LAST_NAME + EMP_FIRST_NAME) as NAME,
EMP_ENG_NAME as ENG_NAME,
substr('EMP_ENG_NAME',1,10) as CUTOUT_STR
from
EMP
order by
EMP_ENG_NAME DESC, EMP_CODE DESC;