SQLselect : RegEx search records where field DOES NOT contain string

[Wonder Fef]

Andy Fuchs wrote:
>> SELECT * FROM myTable WHERE myStrField NOT LIKE 'BCD' no_case
> should be:
> SELECT * FROM myTable WHERE myStrField LIKE '*[^BCD]*'
No, this does not work...

Ruslan Zasukhin wrote:
> Question is: query
>   SELECT * FROM myTable WHERE myStrField NOT LIKE 'BCD' no_case
> do not work for you correctly???
> Or you have not try?
Yes I tried, but it does not work...