[V4RB2] SQL REGEX Help

[Damon Pillinger]

Hi Eric,
I'm no expert but these all look fine to me.

> SELECT Name FROM Clients
> WHERE Name LIKE 'eme'
> --> return absolutely no record at all

this one fails as you have asked like but it is looking for 'eme' only

if you do this
WHERE Name LIKE '%eme%'

You should get anything with 'eme' in it similar to REGEDIT results.

> --> returns clients such as "Diop Systeme", "France Espace
> Developpement" and "Maracadé Evénement"

Thanks

Best Regards

Damon L. Pillinger
Jensen 2005 by Daisychain
www.daisychain.no-ip.biz
Phone : 03 9532 1220
Fax : 03 9532 1280


-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ruslan
Zasukhin
Sent: Thursday, 30 June 2005 2:25 AM
To: valentina at lists.macserve.net
Subject: Re: Re[2]: [V4RB2] SQL REGEX Help

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]


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina