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

from EMP;

---order by