Re: substitute null values in SQL query?

From: Mike Heisz <mheisz_at_rim.net>
Date: Wed, 30 Jun 1999 12:21:25 -0400
Message-ID: <newscache$sre5ef$2re$1@njord.rim.net>

Try using NVL(expression, 0).

This should return the value of the expression except when it is null it will return 0.

Hopr this helps.
<wykoff_at_my-deja.com> wrote in message news:7lbn11$vge$1_at_nnrp1.deja.com...
> Hi,
>
> Once again I need equivalent SQL behavior to an SQL Server query in
> ORACLE.
>
> The value in the select is the difference in dates unless the difference
> returns NULL. In this case it returns 0 (via IsNULL()). I'm looking
> through the SQL Language reference, but I'm not coming up with anything.
>
> Thanks for your help,
>
> kim
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Wed Jun 30 1999 - 11:21:25 CDT