SQLselect : RegEx search records where field DOES NOT contain string

[Ruslan Zasukhin]

on 3/26/03 4:02 PM, Andy Fuchs at andy at foxwerk.de wrote:

> at 26.03.2003 14:09 Uhr, Wonder Fef wrote:
> 
>> SELECT * FROM myTable WHERE myStrField NOT LIKE 'BCD' no_case
> 
> should be:
> 
> SELECT * FROM myTable WHERE myStrField LIKE '*[^BCD]*'

Andy, I think this means to find strings that do not have B or C or D.

    ^BCD is reverse of char-set

> should work (although I cannot test (see previous mail :-))


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