thanks big d
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of dennis
Sent: Friday, July 20, 2001 2:59 PM
To: [EMAIL PROTECTED]
Subject: RE: Null In View
use the IFNULL function
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Crued @ Enteract
Sent: Friday, July 20, 2001 2:46 PM
To: [EMAIL PROTECTED]
Subject: Null In View
In my column list in my view, i'm using an IFEQ expression that needs to
evaluate if that field contains null (-0-). I've tried IS NULL, IS NOT NULL
(reverse logic), -0-, '-0-', ' ', '', and none of them work. Anybody know?
Thanks,
Eric
