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?