>>Hi all,
>>
>>Is there a (sql) command that can calculate the number of unique records of a field into a table with just one command in VFP 5?
>>
>>Thanks beforehand.
>
>How about
>
>

SELECT COUNT (DISTINCT yourfield) FROM yourTable INTO ARRAY aTemp

Are you sure this would work in VFP5?