SQL Case Sensitive ?


I'm trying a query with SQL LOCAL of Paradox (IDE Delphi 5)

It's a select on a column Name, and after it must do a group by name.

so :

Select Name, count(*)
From MyTable
Group by Name

But if a name is 'Sylvain' or 'SYLVAIN' or 'sylvain', the group will do a
distinct on case sensitive.

Result :

Sylvain        3
sylvain         2

and should be for example :


I have tried :

Select Upper(Name), count(*)
From MyTable
Group By Upper(Name)

but SQL Local doesn't support it.

Any suggestions ?

Sylvain JAMES