I was going to try writing a query using a cursor and see if that would work to find and delete the dups, but when looking for good ref. I found http://www.sql-server-performance.com/rd_delete_duplicates.asp
I think that is a very good example to do exactly what you are looking for. (I think) Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -----Original Message----- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 1:11 PM To: SQL Subject: This should be so easy, but I'm getting stumped...(duplicate entries) Pseudocode: "delete every entry in MyTable where MyTable.Email is duplicated" Trying to take a list with possible duplicate entries and remove all the duplicates except one so that all are left is a single instance of an email address, regardless of capitalization Table: EmailAddresses Column: Email That's all. It sounds deceptively easy, doesn't it? Lol... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://affiliates.macromedia.com/t.asp?id=2439&p=go/dr_text_aff1 Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1669 Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:>
