>>Huh? I know, its a strange subject line. Here's my problem. Through something of a snafu we have about 600 records in a table that are improper duplicates of other records. We want to remove them. This would be easy with select distinct EXCEPT that one field "sequence" was provided to create a unique sequence number for each record. So, they are all distinct because they all have different sequence numbers. I can get around this by selecting into a cursor, deleting the sequence numbers, and then selecting dist from the cursor. This gives me the truly distinct records albeit without the sequence numbers. Now I need to put the original sequence numbers back. Any ideas on how to do this?
>
>
>Can you do something like:
>
>Select max(seqfield), field1, field2, field3, etc from table into cursor crsrname group by field1, field2, field3, etc
>
>Will that give you your distinct records?

On the surface at least that seems to work. Thank you very much. I've never really understood the GROUP BY clause. Is there a simple explanation for dummies of what it does?

Thanks again