[thelist] SQL: Like 'S%', but not like '%safety%'

[Peter Brunone (EasyListBox.com)]

Hi Rob,

	If you're going to do it this way, you need an AND in your
second subclause.

...and ((o.PONumber like 'C%'  OR o.PONumber like 'S%') and (not
o.PONumber like '%safety%' AND not o.PONumber  like '%saftey%')) ORDER
BY ...

	The way you had it, you wanted something that was not 'safety'
(which is true of 'saftey') OR something that was not 'saftey' (which is
true of 'safety').

Cheers,

Peter

-----Original Message-----
From: thelist-bounces-evolt=easylistbox.com at lists.evolt.org On Behalf Of
Rob Smith

Howdy,

I'm trying this simple simple SQL query, but for some odd reason, it's
not working. The subject line is pretty much it. Specifically:

...and ((o.PONumber like 'C%'  OR o.PONumber like 'S%') and (not
o.PONumber like '%safety%' or not o.PONumber  like '%saftey%')) ORDER BY
...

I want to pull up PO's that begin with 'C%' or 'S%', but at the same
time, it's also pulling up PO's with the word Safety (and the misspelled
variety of Saftey). 

Any ideas?

Rob Smith