Re: NULL values in arithmetic

Great, thanks I'll give that a try.

Still don't understand the logic behind "nothing plus something = nothing" though!

Klaus Zeuch <KZeuch_at_nospamhotmail.com> wrote in message news:8m9skk$oa4$18$1_at_news.t-online.com...
> Hi,
>
> that's normal - nothing plus anything is nothing...
>
> "Workaround": use the nvl-function to replace occurrences of NULL with 0,
> e.g.:
> select (15+nvl(NULL,0)+8+4) from emp;
>
> Klaus
>
> "Matt Pryor" <matt_at_ddm-net.com> schrieb im Newsbeitrag
> news:965243472.345182_at_lnd-hst-1.atlas.net.uk...
> > 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 Thu Aug 03 2000 - 00:00:00 CDT