[thelist] removing redundant entries

[Anthony Baratta]

At 11:22 AM 10/6/2002, D. Bruce Saurer wrote:
>I have a comma deliminated dump from a database
>that had corrupted.  1600 unique rows became 25,600.
>How can I remove the redundant lines keeping the original?

If your problem is truely redundant lines, suck them all into a new DB. If
your DB Engine supports "Select Into", you could then select all the
distinct records and move them into a new table.
---
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."