SELECT EMP_CODE AS CODE, EMP_LAST_NAME,EMP_FIRST_NAME,'''' || REPLACE(EMP_KANA_NAME,'_','') || '''' AS KANA_NAME,DEPT_CODE,VALID_FLG FROM EMP ORDER BY EMP_CODE DESC;