[V4RB2] SQL REGEX Help

[Eric Ferrer]

Hello all,


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:
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!

Thanks
Eric