select field1, field2, field3
from table
where field3 not like 'text1'
or field3 not like 'text2'
or field3 not like 'text3'
------------------------------------
That is what I am doing right now, but what happens if I have 20-30 text strings? Do I have to write "field3 not like 'text#'" for each one?
Roman




Reply With Quote