is there any method to coerce possible null from aggregate function to zero,
eg
select sum(amt) from balc where 1=0
it returns null, but I want 0 instead.

regards,
bill