>>>Hi All:
>>>What's the easiest and most elegant way to remove the SECOND duplicate.
>>>IOW, when there is a dupe, get rid of the second record.
>>>Thanks,
>>>Yossi
>>
>>
>>There may be a better way. I have used this.
>>
>>

* Prepare the table for the operation
>>SELECT tableWithDuplicates
>>ALTER TABLE ADD COLUMN lDuplicate L
>>
>>* Mark everything initially as a duplicate
>>REPLACE ALL lDuplicate WITH .T.
>>
>>* Create an index of unique records
>>INDEX ON my+Unique+Key+Fields UNIQUE TAG dupTemp
>>
>>* Mark every unique record as not being a duplicate (the nature of the INDEX ON command mandates that the UNIQUE records are top-most in row order)
>>REPLACE ALL lDuplicate WITH .F.
>>
>>* Remove the index
>>SET INDEX TO
>>
>>* The records which are marked lDuplicate = .T. are the second (and later) duplicates
>>
>>* Delete those records and then PACK, mark lDeleted = .T., or whatever...
>>
>>ALTER TABLE DROP COLUMN lDuplicate
>>DELETE TAG dupTemp
>>

>Sorry Rick,
>I am afraid this will not work since Yossi replied the key's are same therefore not unique.
>Yossi wants to delete the second record, whatever that means, containing corrupt data.
>Better to make a SQL select on corrupt data conditon, however Yossi has not replied what qualifies his data as begin corrupt.
>Rgds,
>Koen


It will work. The key fields I mention are not table keys, but uniquely identifying index keys.