Michel,
? SQLExec(lnHandle,"SELECT YEAR(AddDate) AS Test FROM News GROUP BY YEAR(AddDate)")
should work
Walter,
>>did you try grouping on a fieldnumber ?
>>
>>
>>? SQLExec(lnHandle,"SELECT YEAR(AddDate) AS Test FROM News GROUP BY 1")
>>
>
>From all my tests so far, SQL Server don't support a group by by using an integer as a reference. I only succeeded when using existing field names.