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
Brian Campbell.vcf
Description: Binary data
