How to search in a column for information that does not contain certain characters

Question

I'm trying to limit my results in a query by ruling out certain characters. For example, Column A is always constant, but can have multiple returns in column B. I need to rule out everything in column B that contains "WWW", but I'm not excactly sure how to do it.

Answer 1

add a where clause:

select x.a,x.b from foo x where x.b not like '%www%'

i you always wanna see a column then

select x.a, case when x.b not like '%www%' then b else null end from foo x

hope it helps...

Answer 2

Try using:

...
WHERE columnB NOT LIKE '%WWW%'