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.


2.______
How do create a UDFs for use with SQL select involving the group by clause ?
SELECT field1, MY_UDF(field2) from table1 group by field1

MY_UDF only returns values for each record not a group of records.