No, I want the number of occurance of each text regardless of the case of the text (case-insensitive). For exemple,

LAVAL = laval = Laval

The GROUP clause of the SELECT-SQL take into accoutn the case of the text, I don't want that.

>SELECT City, 001 AS Count FROM MyTable

>
>>Let say I have this table:

City
>>----
>>Notre-Dame-de-L'Ile-Perrot
>>Notre-Dame-de-l'Ile-Perrot

When I run this query

SELECT City, Count (*) FROM MyTable GROUP BY 1

I have this result:

Notre-Dame-de-L'Ile-Perrot, 2

What I want is:

Notre-Dame-de-L'Ile-Perrot, 1
>>Notre-Dame-de-l'Ile-Perrot, 1

How can I get this result?