From: Mirjam Besamusca <Mirjam.Besamusca@...>

> I have a SELECT statement in which I want to group the data by the month

of

> a date field, to calculate monthly averages. GROUP BY does not allow the
> month function though - is there any way around this?

IMHO, Why dont you make a dummy-smallint-field containing the month of the
date-field.
You can make a before-post-trigger , so the dummy-field value
is always the accurate month of the date-field.

Rusmin Noer