>What is the best method to identify duplicate records in a table?
>In this case there is approx 1.5 million records and i need to look at
>each field.
>
>your help will be appreciated.

I dont know if this is the best way, but I programmatically check my tables for duplicate records (meaning all fields the same in more than 1 record) with SELECT DISTINCT * FROM MYTABLE into MYARRAY and compare RECCOUNT() OF original table to _TALLY. If _TALLY is less then I ZAP original table and APPEND FROM MYARRAY. HTH