I am faced with an interesting dilemma. What I need to do is look at a set of records and determine which ones to keep. The records look like this: ID Units Dollars N123456 30 45 123456 35 50 333444 100 200 333555 200 400 I need to look at the ID field to see if there are duplicates when you exclude the leading 'N' from the records that contain them (this will be a small subset of the records). Easy enough. The 2nd part, though, is what is giving me trouble. If there are duplicates, I need to keep the entire row of the record with the leading N and discard the other. So, from the above 4 records, I need to return a set that includes the 1st, 3rd, and 4th rows and get rid of the 2nd row. Hopefully I've been clear enough. If not, I apologize. Thanks in advance for any suggestions.