Re: How do I make 2 + Null = 2 ?
From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1996/02/15
Message-ID: <Pine.SUN.3.91.960215151744.10551C-100000_at_seatimes>#1/1
Date: 1996/02/15
Message-ID: <Pine.SUN.3.91.960215151744.10551C-100000_at_seatimes>#1/1
On Wed, 14 Feb 1996, Russell Foster wrote:
> The problem is that if col3 is null in a row then the derivedcol returns
> null, regardless of the value of col2.
Look at the NVL function.
+----------------------------------------------------+ | Steve Butler Voice: 206-464-2998 | | The Seattle Times Fax: 206-382-8898 | | PO Box 70 Internet: sbut-is_at_seatimes.com | | Seattle, WA 98111 Packet: KG7JE_at_N6EQZ.WA | +----------------------------------------------------+All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Thu Feb 15 1996 - 00:00:00 CET