select EMP_CODE CODE
     , EMP_LAST_NAME || EMP.EMP_FIRST_NAME as NAME
     , EMP_ENG_NAME ENG_NAME
     , ifnull(substr(replace(EMP_ENG_NAME, ' ', ''), 1, 10), '未入力') CUTOUT_STR
from EMP
order by 4 desc, 1 desc;