At 25/02/2002 07:26 PM, you wrote:

>Select extract (month from sales_transaction.transaction_date), count(*)
>from sales_transaction
>Group by extract(month from transaction_date)
>
>But I receive a complaint on line three any ideas ?
>

You can't use GROUP BY that way. I know that with FB 1.0 RC2, you can use
a UDF in a GROUP BY and there are some(i.e. FreeUDFLib from Greg Deatz)
that already exist to extract the month.


Daniel Rail