SQL LIKE

[Ruslan Zasukhin]

On 12/31/04 8:53 PM, "jda" <jda at his.com> wrote:

>>> Looking at the latest SQL docs for V2 (p. 24), it seems that LIKE
>>>  should be acceptable for searching (equal to REGEX). But it doesn't
>>>  work for me. Should it? Or am I misreading the documentation?
>> 
>> It is not such powerful as REGEX,
>> 
>> Show your examples, Jon.
>> 
> 
> Oh, OK. I tried to do a case-insensitive search with
> 
> authors LIKE '(?i)ruslan'
               ^^^^ this is regex command!

If you want in 2.0 do the same you need \

    authors REGEX '(?i)ruslan'


> and got no hits (worked with REGEX '(?i)ruslan'



> I also tried

> authors LIKE 'ruslan' no_case and got an error (Table no_case not found).
                      ^^^^^^^^^^
                    no_case key word from 1.x not implemented yet in 2.0


> Maybe the V4RB pdf, which shows an example like this on p. 103, is wrong?

I need to check it

-- 
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://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------