SQLselect : RegEx search records where field DOES NOT contain string

[Andy Fuchs]

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]*'

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

-- Andy Fuchs
-- silent movie media
-- mailto:andy at foxwerk.de
-- http://www.silent-movie-media.com