not like statement

[stancho]

Originally posted by rkiss
select field1, field2, field3
from table
where field3 not in ('text1', 'text2', 'text3')

select field1, field2, field3
from table
where field3 not like 'text1'
or field3 not like 'text2'
or field3 not like 'text3'

???