[V4RB2] SQL REGEX Help

[Ruslan Zasukhin]

On 6/29/05 7:19 PM, "Eric Ferrer" <wonderfef at noos.fr> wrote:

> 
> Anyway, I've just made some tests and here are some simple results:
> Note that the field 'Name' in the table 'Clients' has been set as
> "kPrimary" in the CollationAttribute "kStrength"
> 
> SELECT Name FROM Clients
> WHERE Name REGEX 'eme'
> --> returns clients such as "Diop Systeme", "France Espace
> Developpement" and "Maracadé Evénement"
> --> but it does not return clients such as "7ème Apache Films"
> 
> SELECT Name FROM Clients
> WHERE Name REGEX 'ème'
> --> returns only clients with exactly 'ème' in their name, such as
> "Le Public Système", "7ème Apache Films"
> 
> SELECT Name FROM Clients
> WHERE Name LIKE 'eme'
> --> return absolutely no record at all
> 
> SELECT Name FROM Clients
> WHERE Name LIKE 'ème'
> --> return absolutely no record at all
> 
> SELECT Name FROM Clients
> WHERE Name REGEX '(?i)[eè]me'
> --> this one returns expected records, such as "16/9 EME", "Le Public
> Système", "Vivement Lundi"

More simple:

    send to Ivan this database.

And he will repeat searches.

Also please make comment what is correct, and what is no, and why

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