Thanks Lena. I will try that in the morning. (Just giving up for the night as it is almost 1am here).
Thank you. Regards John Docherty Sent from mobile From:"Lena Dammstrom" <[email protected]> Date:Thu, 23 Apr, 2015 at 12:42 AM Subject:[RBASE-L] - RE: Detecting duplicate values in a table You could do a Select FieldName, Count(*) from TableName Group By FieldName having count(*) > 1 This would give you a list of duplicates Regards Lena From: [email protected] [mailto:[email protected]] On Behalf Of John Docherty Sent: Wednesday, April 22, 2015 7:26 AM 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
