Defaulting NULL values in Informix, ala NVL in Oracle

Posted in 1997

Johan Andersson — 17 Jan 1997 10:00:15 GMT — source: Informix-list mailing list archive (1991-1998)

Is there something similar in Informix to the NVL function in Oracle? The sematics is simple: NVL( expression1, expression2) NVL returns expression2 if expression1 is null otherwise expression1. -- ________________________________________________________________________ | >>> The opinions herein are mine and not neccessarily my employers <<< | | Johan Andersson, Msc CSE jna@carmenta.se | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~