On 3 Nov 2003 at 16:46, Ivan Prenosil wrote:

> No. Aggregate functions (like SUM) automatically skip NULL values,
> so you do not need any additional constructs inside SUM(...).
> SUM() is null if there are no rows to sum, so the COALESCE must be outside
> (like in Arno's examples).

You're right, I didn't spot the error at the first glance. Sometimes the
quick answer is not the best one :-)

Best regards
Pavel Cisar (ICQ: 89017288)
http://www.ibphoenix.com
For all your upto date Firebird and
InterBase information