>I have a VFP6.0 table with a numeric field (named say f1) that supports null values. If I make all records have f1 equal null and issue the following commands:
>
>STORE .NULL. TO x
>CALCULATE AVG(f1) TO x
>
>I expected to see NULL as the result but instead VFP returns 0.000.
>
>Is there anyway to have NULL returned when all values for the field are null?
>
>TIA. Mike

From the help on CALCULATE:

"Records containing the null value are not included in the operations that CALCULATE performs."

SELECT (SQL) does return NULL on aggregate functions.