Sorry, bad syntax, should be something like...
SELECT COUNT(*) as keycount, upper(keyfield) as keyfield1 FROM table1 GROUP BY keyfield1 HAVING keycount >1
>>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