The simplest way is to create an identical table which doesn't allow duplicates and copy the original table into it. The DBMS should do the weeding out for you. Nick -----Original Message----- From: CF-Talk [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 20, 2000 10:11 PM To: [EMAIL PROTECTED] Subject: OT: Delete duplicates in tables ? [CF-Talk] How can I delete only duplicate records in a certain field ? DISTINCT doesn't seem to work, cause I want to delete them and not collect them via a query. Uwe SD Solutions Lange Zeile 27 85435 Erding Fon: 08122/903791 Fax: 08122/903792 Mail: [EMAIL PROTECTED] Web: www.sdsolutions.de ---------------------------------------------------------------------------- -- Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ********************************************************************** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ********************************************************************** ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
