You shouldn't be get the results you are getting...do have more information you can provide?

< update >
Glad to see you have a solution...

>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?
>
>TIA