[V4RB2] SQL REGEX Help

[Ruslan Zasukhin]

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

Hi Eric,

> with Valentina v1, I used to use such statements :
> 
> SELECT Name
>   FROM Clients
>   WHERE Name LIKE 'b\.?[iîïìÎÏÌ]+\.?d\.?' no_case
>   ORDER BY Name
> 
> This was very useful for my needs, because it allowed users to search
> any record in the database, ignoring :
> - case
> - accents
> - dots
> 
> In my example, the user has typed 'bid' and the search engine is
> capable of finding records whose name may be:
> BID
> B.I.D
> bîdo
> BÏDEN
> etc.
> 
> The same SQL statement (I replaced LIKE by the keyword REGEX) fires a
> VException along with this message:

You need remove no_case with 2.0

> Unexpected token: b\.?[iîïìÎÏÌ]+\.?d\.?
> Exception error number: 462848
> 
> SQL92 must have changed something, but I can't find what...
> Any help would be highly appreciated!

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