You can use code like this

lcTableName = < table name >
SELECT (lcTableName)
lcGroup = "1"
FOR lnI = 2 TO FCOUNT()
  IF NOT INLIST(TYPE(FIELD(lnI)), "M", "G")
    lcGroup = lcGroup + "," + TRANSFORM(lnI)
  ENDIF	
ENDFOR

SELECT *, COUNT(*) ;
	FROM (lcTableName) ;
	GROUP BY &lcGroup ;
	HAVING count(*) > 1

>How should one execute a search in VFP for duplicate records knowing only the table name?
>
>I do not know how to pull the field names into the following pseudo-code:
>
>select *, count(*) as cnt from TABLE_NAME;
>group by [ALL THE FIELD NAMES];
>having count(*)>1