not like statement

[balajiyes]

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

I think u trying for this

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