SQLselect : RegEx search records where field DOES NOT contain string

[Ruslan Zasukhin]

on 3/26/03 12:27 PM, Wonder Fef at wonderfef at noos.fr wrote:

> 
> Hello all,
> 
> I like to launch a SQL Query to get records that DOES NOT contain a
> specified string, something like :
> 
> SELECT * FROM myTable WHERE myStrField NOT LIKE 'ABC' no_case
> 
> Any clue?

But your query must work.  No?

I do not remember, NOT LIKE or LIKE NOT is correct syntax.
Check SQL.pdf

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------