Re: Oracle build in function NVL() also in informix?

Posted in 1999

Sujit.Pal@bankofamerica.com — Thu, 18 Nov 1999 10:40:08 -0800 — source: Informix-list mailing list archive (1991-1998)

Werner Yes, if you have 7.31 (maybe in 7.30 too). There is an NVL function which works the same as the Oracle NVL function. HTH Sujit Werner Franke <franke@quantum.de> on 11/18/99 02:56:12 AM Please respond to Werner Franke <franke@quantum.de> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Oracle build in function NVL() also in informix? Hi, in oracle something is possible: select nvl(column_xyz, 'ABC') from table_xyz ... It results 'ABC' when the value of column_xyz in current row is null and the current value if column_xyz is not null. Exists something which is equivalent in informix ?