>1.________
>
>Any standard SQL text gives the STDDEV function as a standard with SQL select. But it does not work with VFP:
>
> select field1, stddev(field2) from table1
>
>I tried STDDEV() - which is the SQL standard and STD() - which is a VFP function. They both don't work.
>
>STD() can only be used with CALCULATE whereas SUM, AVG and COUNT can be used with SQL select.
>

It's not possible for SQL to do standard deviation, since the sum of all the values must be known in advance...it would require two passes through the data...