Whoops! Mea culpa. I misread it. I still like this way the best as it gives all the duplicates rather than just a list of the contents of one of the duplicated fields.

Alan

>I like this way the best myself, but unfortunately, it is not ansi compliant, and won't work in VFP8 without setting enginebehavior first.
>
>Alan
>
>>Allen,
>>
>>How about
>>
>>

>>select * from lineitems ;
>>where lineitems_id IN (select lineitems_id from lineitems ;
>>                       group by 1 ;
>>                       having count(lineitems_id) > 1) ;
>>order by lineitems_id ;
>>into cursor curDupes
>>

>>
>>
>>>>>>>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
>>>>
>>>>
>>>>CntDups becomes a calculated field in your query result (cursor).
>>>>Basically you are saying to group by "lineitems_id" and count how many show up. Then disregard the ones that show up only once and show only 2 or more instances ("having CntDups > 1").
>>>>
>>>>

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

>>>>
>>>>Clearer?
>>>
>>>Thank you. It's clearer and works but I needed another thing...
>>>What you gave me shows the duplicate record and the times it's duplicated, but I was trying to get the duplicate records, record by record. So that each record is listed.
>>>Thanks,
>>>Allen