>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...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.