SQLselect : RegEx search records where field DOES NOT contain string

[Ruslan Zasukhin]

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

>>> I'd 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?
> 
> Example:
> Rec 1 : myStrField = "ABCDEF"
> Rec 2 : myStrField = "ABC"
> Rec 3 : myStrField = "DEF
> 
> SELECT * FROM myTable WHERE myStrField NOT LIKE 'BCD' no_case
> 
> ...would return me Rec 2 and Rec 3, but not Rec 1

I see what you want.

Question is: query 

    SELECT * FROM myTable WHERE myStrField NOT LIKE 'BCD' no_case

do not work for you correctly???
Or you have not try?

I just do not understand what your problem is.

-- 
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
-------------------------------------------------------------