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