Re: Handleing Nulls
From: <rtproffitt_at_my-deja.com>
Date: Fri, 15 Oct 1999 01:34:15 GMT
Message-ID: <7u60am$jrc$1_at_nnrp1.deja.com>
Date: Fri, 15 Oct 1999 01:34:15 GMT
Message-ID: <7u60am$jrc$1_at_nnrp1.deja.com>
If you are testing for nulls in the app
the two ways:
If x is NULL then...., If x IS NOT NULL then... If (x Is not null) and (x = 5) then....
And NVL(x,'MyFlag')....
If NVL(x,'MyFlag') = 'MyFlag' Then
- the item was really null...
Robert Proffitt
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Oct 15 1999 - 03:34:15 CEST