I would like to select all records from a table which are not `like '%select%'` but except these which contains `'%select some_string%'` and `'%select some_other_string%'`. 

How do I do this in T-SQL?