SELECT empno, ename,job FROM emp WHERE REGEXP_LIKE (job, '(sales)', 'i')

Oracle, PostgreSQL and MySQL

SELECT empno, ename,job FROM emp WHERE job like '%SALE%'

PostgreSQL:

 SELECT empno, ename,job FROM emp WHERE job ~ 'SALESMAN'