SQLselect : RegEx search records where field DOES NOT contain string

[Ruslan Zasukhin]

on 3/27/03 6:08 PM, Richard Altenburg at valentina at brainchild.nl wrote:

> On 26-03-2003 16:52, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:
> 
>>> 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...
>> 
>> Send me small db
>> 
>> I will try in viSQL.
> 
> I think the original poster should try this:
> 
> 
>   SELECT * FROM myTable WHERE NOT myStrField LIKE 'BCD' NO_CASE
> 
> 
> So the word NOT should be right after WHERE, and shouldn't be before the
> word LIKE.
> 
> Try it, you might be surprised!

Hi Ricahrd,

Thank you for TIP. You are right.

Eric, I have check it works fine with your project.


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