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.