>>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
>

Sorry but I did get it...
Keyfld for me is lineitems_id
TestDups table is lineitems
What's CntDups... a variable?

Allen