I found NVL in the March 2003 version of "IBM Informix Guide to SQL:Syntax" page 4-92
Terry Maragakis Database Administrator The Inteq Group Inc. 5445 La Sierra Dr. Suite 400 Dallas, TX 75231 214-739-9494 214-739-7979 Fax [EMAIL PROTECTED] www.inteqrx.com ____________________________________________________________________________________________ IMPORTANT: This message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under federal or state law. If you received this communication in error, please destroy and notify the sender by return message or call our Privacy Administrator at 800-324-7799. -----Original Message----- From: CAMPBELL, BRIAN D (BRIAN) [mailto:[EMAIL PROTECTED] Sent: Monday, August 23, 2004 12:08 PM To: 'Priest, Darryl - BALTO' Cc: [EMAIL PROTECTED] Subject: RE: New info on an old Thread: Selecting a record from a table wh ere a column might be null I couldn't find any mention of NVL in my older Informix books (not surprising). But I couldn't find any mention of it in the current online docs either. However, you are right. I tried NVL on our Informix server, and it does accept the function, and it does appear to work as expected. -----Original Message----- From: Priest, Darryl - BALTO [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 5:52 AM To: CAMPBELL, BRIAN D (BRIAN) Subject: RE: New info on an old Thread: Selecting a record from a table wh ere a column might be null Not that it really changes your end solution, but nvl, and a few other "Oracle" functions have been available in Informix for quite a while now, certainly back to version 7.31. HTH, -Darryl