Check your EQ NULL and zero settings. I believe that Null does not equal Null under normal circumstances, so Rbase would not consider a record a duplicate if it contained any null field values.
If you records do not contain any null fields, then you might try rebuilding your indexes just in case something is amiss there. -Bob Thompson Technology Consultants 276 Chippewa LaPorte, IN 46350 219-324-2605 (Phone & Fax) 219-363-7441 (Cell) http://ttc.inc.home.comcast.net -----Original Message----- From: Bernard Lis [SMTP:[EMAIL PROTECTED] Sent: Friday, October 14, 2005 6:51 PM To: RBG7-L Mailing List Subject: [RBG7-L] - delete duplicates I have a table called chemtabl I did: delete duplicates from chemtabl and got 0 rows deleted. I know I have at least 14 rows that are exact duplicates because I projected those rows to another table and then inserted them back into chemtabl. I do not want to specify column names because I want to make sure that they are exact dups. Bernie Lis
