Filter out codes under certain conditions

Question

I need to filter out codes beginning with 45XXX except code that equals 45003

using a where clause:

Select * from table where code NOT IN ('45%') 

will filter out all codes beginning with 45 including 45003 which I still want to include

Is there an easy way to do this?

Answer 1

You could add an OR condition which whitelists the code 45003

SELECT *
FROM yourTable
WHERE code NOT LIKE '45%' OR code = '45003';