Re: Defaulting NULL values in Informix, ala NVL in Oracle

Posted in 1997

Dirk Schmidtpott — 28 Jan 1997 08:02:46 GMT — source: Informix-list mailing list archive (1991-1998)

Hi Johan, unfortunately there is no such function in Informix. I think the solution is to write a stored procedure. Tschuess, Dirk Johan Andersson <jna@carmenta.se> wrote in article <5bnijf$6mk@rocky.carmenta.se>... > > > 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 | > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > >