Nando Dessena wrote:

>
> Paul,
>
> > You can't. There has never been support in InterBase for group by operations
> > on user defined functions. An attempt was made to add this in Beta 2. The
> > feature just didn't work consistently and has now been removed.
>
> AFAICT, he is not grouping by the function.

Sorry, I was being slightly imprecise. Group By has to be applied to all
columns in the result set that are not sum'ed, avg'ed etc - including the
UDF'ed columns. The group by was being done on several columns and the UDF was
on one of the columns not included in the group by. You can't do that.


Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further