>Hi,
>Can someone help me with the SQL to find all duplicates in a field?
>Thanks,
>Allen

select KeyFld, count(*) as CntDups from TestDups group by 1 ;
     having CntDups > 1 ;
     into cursor curDupes