Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL count without French characters
Message
From
02/12/2002 03:04:57
Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL count without French characters
Miscellaneous
Thread ID:
00728525
Message ID:
00728525
Views:
62
I am looking for the best way to have my SQL count functionality to not have specific records to be isolated if they contain French characters but to be taken as if there wouldn't be any French characters.

For example, if my SQL gives presently:

Montréal 234
Montreal 12
Québec 120
Quebec 12

I would like to obtain:

Montreal 246
Quebec 132

Any way to obtain that easily within one existing SQL?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Next
Reply
Map
View

Click here to load this message in the networking platform