select 
    emp_code as CODE,
    emp_last_name||emp_first_name as NAME,
    emp_eng_name as ENG_NAME,
    substr(replace(ifnull(emp_eng_name,'未入力'),' ',''),1,10) as CUTOUT_STR
from emp
order by cutout_str desc,code desc;