Re: DUPLICATE KEYS

In article <38lsio$h5k@emory.mathcs.emory.edu> sheltra@emh-1.submepp.navy.mil writes: > Again, many thanks to those of you who came to my rescue for > a technique for finding the duplicate keys. I'd like to take > the problem a step further. I found that the file I'm > talking about has over 7k records with duplicate keys. Is > there a coding technique I could use to get rid of the dups > other than by the one'zies? I think so - but tell me this: if two records have the same key, but there are other non-key columns that have different values, how are going to decide which one to delete? Is it arbitrary - just throw away either record? Or would you have some criteria to decide which record to keep and which to discard? Paul