[V4RB] Accents in queries

[Lee Swanson]

in most regExp it would be:

Cursor = myDatabase.SQLSelect("Select Name from myTable where Name like
'premi[eè]re' no_case")





-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net]On Behalf Of Wonder Fef
Sent: Tuesday, 28 January 2003 7:15 PM
To: Valentina Developers
Subject: [V4RB] Accents in queries



Hello all,

I have a SQLSelect statement:

Dim cursor as Vcursor

Cursor = myDatabase.SQLSelect("Select Name from myTable where Name like
'premiere' no_case")

The cursor gives me access to all matching rows, excepting rows containing
"première", which is bad for my use.

I looked into the RegEx documentation but I can't understand how to use the
directives.

Any help will be highly appreciated.
Thanks
Eric

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