here's what I usually use:

select field, count(field) as cnt;
 from table;
 group by 1 order by 2;
 having cnt > 1

>I know there was a thread here recently that discussed finding duplicates using SQL... but the UT search seems to be broken, so I'll ask if anyone can provide the thread # or sample code.
>
>TIA