Is there a key to the table or a column with unique values? -----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... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1662 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:> This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
