It's really quite simple

INDEX ON Name UNIQUE
COPY TO NewTable

Delete the original table, then copy the new one in its place.

>I have a Table (Has 3 million entries) and need to do some analysis / cleansing on it
>In its simplest form , is is a Table with one column, called Name, and holds following data
>John Jones
>Johnny Jones
>Mary Black
>Mary Ann Black
>Padd Reilly
>Paddy O'reilly
>Barrack O Bama
>Barrack O'Bama
>Barry O Bama
>George Bush
>Georg Bush
>
>etc
>
>I need to come up with a list of unique entries, using some 'Consolidation factor'
>The 'Consolidation Factor' can be arbitrary as long as its transaparent and everybody knows what it is
>So above would translate to 5 entreis
>John JOnes
>Mary Black
>Paddy reilly
>Barrack O bama
>George Bush
>
>
>Anybody aware of any tools around that does this sort of thing. Can be Foxpro or C#.
>
>Tia
>Gerard