SELECT
    EMP_LEN.CODE CODE
    ,EMP_LEN.ENG_NAME
FROM (
SELECT
    EMP_CODE        AS  CODE
    ,EMP_ENG_NAME    AS ENG_NAME
    ,substr(upper(EMP_ENG_NAME),INSTR(upper(EMP_ENG_NAME)  ,'S')+1,length(EMP_ENG_NAME)) AS ENG_NAMESEIGEN
FROM EMP
WHERE INSTR(upper(EMP_ENG_NAME)  ,'S' ) > 0
) EMP_LEN
WHERE INSTR(upper(EMP_LEN.ENG_NAMESEIGEN)  ,'S' ) > 0
ORDER BY EMP_LEN.CODE