SELECT
    emp_code AS CODE
    , emp_last_name || emp_first_name AS NAME
    , emp_eng_name AS ENG_NAME
    , CASE
        WHEN emp_eng_name IS NULL THEN '未入力'
        -- 半角スペースを削除して，先頭10文字を取得
        ELSE SUBSTR(REPLACE(emp_eng_name, ' ', ''), 1, 10)
    END AS CUTOUT_STR
FROM
    EMP
;