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;