This should be quite simple but I can't find how to make that work. I am trying to group by on an expression field such as:

? SQLExec(lnHandle,"SELECT YEAR(AddDate) AS Test FROM News GROUP BY Test")

But, the only GROUP BY clause I can use is on a existing field. How can I GROUP BY on an expression?