You would get the same result in VFP9 as if you run such query agains MS SQL Server or any other ANSI Standard compliant backend.

>I found it. That seems to make things entirely non-intuitive.

>Select SUM(AMOUNT), COUNT(*) from SomeTable where NAME="SMITH"

>If there are no SMITHs, the query should either return no records or a record with everything zero. Instead it apparently returns data with one or more of the fields as NULL in the one-record recordset. In my actual code, I'm using SQL like :

>Select str(sum(Amount),5) as cNAmount, str(Count(*),5) as cNCount...

and I'm getting back nulls.
>