Keep in mind when using "delete duplicates". If you have EQNULL OFF, then nulls in columns will never match. So if there's a possibility of nulls, put EQNULL ON before you do the delete dup command.
Karen -----Original Message----- From: Tony IJntema <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, Apr 22, 2015 7:46 am Subject: [RBASE-L] - RE: Detecting duplicate values in a table DELETE DUPLICATES FROM <tablename> USING columnname [,...] Tony From: [email protected] [mailto:[email protected]] On Behalf Of John Docherty Sent: woensdag 22 april 2015 14:26 To: RBASE-L Mailing List Subject: [RBASE-L] - Detecting duplicate values in a table I would appreciate some advice on how to detect duplicate values for a column in a table. Apart from using a cursor to go through each row and then looking for rows with the same value is there any quicker way of doing this ? Any suggestions would be appreciated. Thank you. Regards, John Docherty
