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

Thanks! And thanks to all!