>SELECT COUNT(*) as keycount, keyfield FROM table1 GROUP BY upper(keyfield) ORDER BY upper(keyfield) HAVING keycount >1
>
>Also, if you have a large table, make sure that you have and index on upper(keyfield)
>Hope this helps //:^)
>

The above is exactly what I'm looking for, thanks! What really confused me though is that my MS SQL Server will find a duplicate record if I issue the following:

SELECT licnum FROM drivauth GROUP BY licnum HAVING COUNT(*)>1

And the licnum in one record is "s422" and the other record is "S422"

Jeff