select
EMP_CODE  CODE
,EMP_LAST_NAME || EMP_FIRST_NAME NAME
,EMP_ENG_NAME  ENG_NAME
,case  
  when EMP_ENG_NAME is null then '未入力'
  else substr(replace(EMP_ENG_NAME,' ',''), 1, 10) 
 end  CUTOUT_STR

from EMP

order by 4 desc,1 desc;