NULL values in arithmetic

Hi there,

I'd expect the following query:

    select (15+NULL+8+4) from emp;

to ignore the NULL and return the sum of 15,8 and 4. Instead it returns NULL. Is this normal? Why is it? Is there a workaround?

Thanks in advance for any help,

Matt Received on Wed Aug 02 2000 - 00:00:00 CDT