On Thu, 25 Jul 2002, Vincent Stoessel wrote:
> now my problem comes into play when one of the
> columns is empty. I always get a NULL or empty total.
> this makes sence since NULL + 5 does not produce anything.
I think colesce is your friend
select cola, colb, sum(colesce(cola,0) + colesce(colb,0)) from ....
I've never had to use it put I've seen this situation addressed here
before. Table 9.3, pg 113 the Elephant book.
Rod
--
"Open Source Software - Sometimes you get more than you paid for..."