Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: adding 1 to NULL = 1?
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:
>
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