> Alan McDonald wrote:
>
> >>This is not something I need right now, but I'm curious: is it possible
> >>to add aggregate functions as UDFs?
> >>
> >>If not, are there any plans to add support for this?
> >
> > Do you mean SUM(), AVG() etc? if so then they are already
> internal to the
> > engine.
>
> Yes, I mean that KIND of function, but assume you'd want to return for
> example a concatenation of the values in a column:
>
> select Concat_UDF(ITEM)
> from STUFF
> group by CATEGORY
>
> Rather obscure, I know. Like I said, I was just curious.
>
> Kjell

select CATEGORY, sum(FIELDNAME) from TABLENAME group by CATEGORY

If that's what you want then use it - it's there for you to use
Alan