>

lcWithAccent = 'éàì..'
>lcWOAccent = 'eai..'
>select chrtran(city,lcWithAccent,lcWOAccent) as myCity, cnt(*) ;
> from myTable ;
> group by myCity
>

Cetin

Isn't there a way to make that generic? I believe I received something like that a few months ago and was wondering if I could apply it here.