>Hi Friends!
>
>How can I delete all duplicate records from a table?
>
>TIA

Typically you may issue SQL statement like this:

SELECT myfieldname, COUNT(myfieldname) ;
	FROM mytable ;
	GROUP BY myfieldname ;
	HAVING COUNT(myfieldname) > 1 ;
	INTO CURSOR mycursor

You might try also some utilities in Download section:

file#289
file#9631