First, as others have mentioned yesterday and today, NULL is *NOT* a value,
it's a state. A state of unknown value. To check for NULL:

if xxxx IS NULL

of

if xxx IS NOT NULL


Best,
Fred Wilson
SE, Bell & Howell
fred.wilson@... <mailto:fred.wilson@...>



-----Original Message-----
From: jyotindra_bhoyania [mailto:jyotindra_bhoyania@...]
Sent: Thursday, January 31, 2002 1:38 AM
To: ib-support@yahoogroups.com
Subject: [ib-support] How to check Null Values


Dear Friends,

I am stuck in problem.

How to check Null Values.
Is there some Function for Null. (For example in oracle their is NVL
function).
How many bites does Firebird Interbase (6) stores for NULL values.
Please help for check null values and replaceing null values with
zero.

waiting for promt reply.

Thank's
jyotindra.




Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=218512.1856015.3360178.1269402/D=egroupweb/S=17050077
09:HM/A=928901/R=0/*http://ad.doubleclick.net/clk;3788034;6800959;v%3fhttp:/
/www.verisign.com/cgi-bin/go.cgi?a=b228473240057000>

<http://us.adserver.yahoo.com/l?M=218512.1856015.3360178.1269402/D=egroupmai
l/S=1705007709:HM/A=928901/rand=296596091>

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .