>>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?
It looks like you're looking for
select LEFT(DTOS(myTable.MyDateField),6) as lcChampNumero,
count(*) as Compte, MIN(MyTable.MyField) as AddDate
from myTable
GROUP BY 1
If it's not broken, fix it until it is.
My Blog