>Say you have a table xyz with a an id field named id type char.

>USE xyz
>RECALL ALL
>INDEX ON Id TAG Id UNIQUE
>
>SET ORDER TO Id
>DELETE ALL
>
>SET ORDER TO
>
>BROWSE FOR DELETED()

< SNIP >

The code above would leave only duplicates of records in the table.

Here's the code according to May 1997 article in FoxTolk 'A "UNIQUE" Approach to De-duping in FoxPro'

SET DELETE OFF
USE xyz EXCLUSIVE
DELETE ALL
INDEX ON Id TAG Id UNIQUE
SET ORDER TO Id
RECALL ALL
SET ORDER TO
SET DELETE ON

See Message #565094 for limitations of this method