Replacing LIKE with REGEX doubts

[Ruslan Zasukhin]

On 11/24/05 6:32 PM, "Stan Busk" <maxprog at mac.com> wrote:

> Hi,
> 
> Am I right if I continue using LIKE this way?:
> 
>      Is equal to: myField LIKE 'mytext'
> Is not equal to: myField NOT LIKE 'mytext'
>         Contains: myField LIKE '%mytext%'
> Doesn't contain: myField NOT LIKE '%mytext%'
>      Starts with: myField LIKE '%mytext'
>        Ends with: myField LIKE 'mytext%'
> 
> Is new Valentina 2 LIKE case insensitive? or is it case sensitive?

It is depend on Database/Table/Field settings.

> What characters do I need to escape, the '%', '_' and '/' ?

    only 2:   '   \

> Is it faster than REGEX? Right now it looks easier.

I think it is little faster because simpler rules.


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