CODE EXAMPLE FOR SQL

get employees if not contains in sql

SELECT JOB_ID 
FROM EMPLOYEES 
WHERE JOB_ID NOT LIKE '%REP' ;