Replacing LIKE with REGEX doubts

[Ruslan Zasukhin]

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

Hi Stan,

> Hi,
> 
> Just wondering some of the Valentina v1 LIKE equivalents using v2
> REGEX of
> 
>      Is equal to: myField LIKE '\Amytext\Z' no_case
> Is not equal to: myField NOT LIKE '\Amytext\Z' no_case
>         Contains: myField LIKE 'mytext' no_case
> Doesn't contain: myField NOT LIKE 'mytext' no_case
>      Starts with: myField LIKE '\Amytext' no_case
>        Ends with: myField LIKE 'mytext\Z' no_case
> 
> 
> are they?:
> 
> 
>      Is equal to: myField REGEX '(?i)mytext'
> Is not equal to: ???
    
            myField REGEX NOT '(?i)mytext'
            myField NOT REGEX '(?i)mytext'

>         Contains: myField REGEX '(?i)[a-zA-Z0-9]+mytext[a-zA-Z0-9]+'
> Doesn't contain: ???
>      Starts with: myField REGEX '(?i)[a-zA-Z0-9]+mytext'
>        Ends with: myField REGEX '(?i)mytext[a-zA-Z0-9]+'
> 
> If I am right with [a-zA-Z0-9]+ is there something better and wider?
> I mean that could consider more possible characters?

I believe that in Valentina SQL.pdf exists text about how todo INDEXED
searches 
            StartsWith, Like, ...


2) note new feature:

    db.CollationAttribute( kStrength ) = kPrimary

This give you the wole db case-insensitive.


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