Re: NVL in Informix?

Posted in 1998

Mark D. Stock — Wed, 11 Feb 1998 20:17:13 +0200 — source: Informix-list mailing list archive (1991-1998)

P.Xeros wrote: > > If a (char)column has null values and you concatenate(||) this column > with another non null(char), then you will get a null > value(expression). > Oracle for example has NVL(column, "value") function > which allows you to "say" what value you want to be returned > if the value of the column is null. Is there any way to do this in > Informix without writing 4gl code(just SQL statements)? What about a stored procedure? I believe 7.30 will include such a function. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+