>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

Thanks!