> Regrettably the example was a simplified case to expose the problem.
> The real query is a sub consult with external links and I cannot use
> stored procs.
> I was looking for a SQL expression, or maybe I need to create a UDF to do
> some thing like:
>
> SELECT SUM_EX(Age) FROM Persons
>
>
> In any case, thank you for your prompt reply.

Are UDFs on groups of records even possible?

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!