SELECT
EMP.EMP_CODE AS CODE
,EMP.EMP_LAST_NAME || EMP.EMP_FIRST_NAME AS NAME
,EMP_ENG_NAME AS ENG_NAME
,CASE
WHEN SUBSTR(REPLACE(EMP_ENG_NAME,' ',''),1,10) IS NULL THEN '未入力'
ELSE SUBSTR(REPLACE(EMP_ENG_NAME,' ',''),1,10)
END AS CUTOUT_STR
FROM
EMP
ORDER BY
CUTOUT_STR,CODE DESC