select EMP_CODE CODE, EMP_LAST_NAME||EMP_FIRST_NAME NAME, EMP_ENG_NAME ENG_NAME,
 ifnull(SUBSTR(replace(EMP_ENG_NAME,' ',''),0,10),'未入力') CUTOUT_STR
from EMP
order by CUTOUT_STR desc ,CODE desc

;