RE: [KCFusion] SQL help

[Eddie B. McReynolds]

where {column_name} IS NOT NULL   Eddie McReynolds Architecture Software Analyst Clinical Reference Laboratory Voice:  (913) 693-2512  (800) 445-6917 Ext.: 2512 Fax:    (913) 492-4316    Email:  [EMAIL PROTECTED] OUR VALUES & CULTURE * Service to Humanity * Flexibility * Commitment * Compassion * Teamwork * * Perseverance * Quality * Integrity * Client Focus * -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adaryl Wakefield Sent: Monday, May 03, 2004 12:19 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] SQL help Oh wait let me refine this better. Im trying to see where fields are NOT NULL. I try <> NULL but that does not seem to work.   Adaryl "Did you reboot?" Wakefield Aviator by passion Programmer by sheer force of will ----- Original Message ----- From: Bruce Dunwiddie To: [EMAIL PROTECTED] Sent: Monday, May 03, 2004 12:08 PM Subject: RE: [KCFusion] SQL help Isnull( column, valueifnullgoeshere)   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adaryl "Bob" Wakefield Sent: Monday, May 03, 2004 12:05 PM To: [EMAIL PROTECTED] Subject: [KCFusion] SQL help   This is really silly but for some odd reason I can't come up with the magic formula to check for NULLs in a SLQ server 2k database.   Adaryl "Did you reboot?" Wakefield Aviator by passion Programmer by sheer force of will DISCLAIMER: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you.