>Not disagreeing with your primary key statement, but if you do get stuck having to locate duplicate records, a faster way than Roxanne's is to start with your idea, Select with Grouping on a field that is often different, like a name. This will reduce the number of records...then do Roxanne's idea of Select distinct * for rest...

Wow Bruce thats a great idea! Much more reliable not to mention efficient... thank you very much, there is one table I cant use this grouping technique on, but for all the other tables it will be much better!!! :D)