NVL in Informix?

Posted in 1998

P.Xeros — Wed, 11 Feb 1998 13:33:13 +0200 — source: Informix-list mailing list archive (1991-1998)

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)? Thanks for your time, P.Xeros