If SQL Server is ANSI SQL and VFP 8 is, how come the following two lines can't be run as is:

SQLExec(lnHandle,"SELECT YEAR(AddDate) AS Test FROM News GROUP BY YEAR(AddDate)")
SELECT YEAR(AddDate) AS Test FROM News GROUP BY YEAR(AddDate)

VFP doesn't support GROUP BY on expression but SQL Server does. So, does that mean VFP 8 supports only some of ANSI SQL or is it that this is specific to SQL Server and doesn't apply to ANSI SQL?