Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: adding 1 to NULL = 1?

Re: adding 1 to NULL = 1?

From: Mike Morgan <mmorgan1_at_mail.tds.net>
Date: Mon, 19 Apr 1999 21:57:39 -0500
Message-ID: <7fgqfe$k8d@news2.tds.net>


But NULL means "unknown". If you add 1 to an unknown value, you still should get an unknown answer. If SQL*Server thinks it should be 1, then that is SQL*Server's problem.

Aaron Ogren wrote in message <371B89F5.11AED159_at_lucent.com>... Hans Nesbø wrote:

>

> Use NVL - NULL-Value Substitute.
> The format is:
> NVL(value, substitute)
> If value is NULL, this function is equal to substitute

Actually, I don't want to use NVL because 1+NULL=1 works under SQL*Server; SQL*Server does not know NVL and I don't want to add Oracle-specific code...Are there any other methods?

Thanks,
Aaron

[...snip...] Received on Mon Apr 19 1999 - 21:57:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US