Sorry typo in last (missed on copy-paste)...

Try something like this (substitute the field for the actual field name that you want to check for duplicates on):

SELECT field,COUNT(field) AS dupcount ;
FROM table ;
GROUP BY field;
HAVING dupcount>1 ;
INTO CURSOR c_dupes