REGEX search

[Ruslan Zasukhin]

On 12/28/09 1:25 PM, "Ruslan Zasukhin" <ruslan_zasukhin at valentina-db.com>
wrote:

>> Try following:
>> Select * from theTable where theField REGEX '\\bthe\\b'
>> 
>> It works for me
> 
> So, as I have told, we need escaping of value ...
> 
> Thank you, Ivan.

Just a remind:

Usually code should looks as

 val = "\bthe\b"   // value to find. User can give it
 val_esc = Valentina_EscapeString( val );

 query = "Select * from theTable where theField REGEX " + val_esc



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]