SELECT
    EMP_CODE AS CODE,
    EMP_ENG_NAME AS ENG_NAME
FROM
    emp
WHERE
    EMP_ENG_NAME GLOB "*S*"
AND EMP_ENG_NAME GLOB "*s*"
ORDER BY EMP_CODE ASC 
;