>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?
lcWithAccent = 'éàì..'
lcWOAccent = 'eai..'
select chrtran(city,lcWithAccent,lcWOAccent) as myCity, cnt(*) ;
from myTable ;
group by myCity
Cetin