Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL count without French characters
Message
De
02/12/2002 03:04:57
Michel Fournier
Level Extreme Inc.
Petit-Rocher, Nouveau-Brunswick, Canada
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SQL count without French characters
Divers
Thread ID:
00728525
Message ID:
00728525
Vues:
63
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform