>Can someone confirm me if that SQL syntax is supported in VFP?
>
>

>SELECT CONVERT(CHAR(4),YEAR(MyTable.MyField))+REPLACE(STR(MONTH(MyTable.MyField),2),' ','0') AS lcChampNumero,
> COUNT(*) AS Compte,MIN(MyTable.MyField) AS AddDate
> FROM MyTable
>

You need to group by some field and also CHAR and CONVERT are SQL Server functions. Although it's easy enough to find VFP replacements.

Can you explain what do you want to achieve?