NULL Values

Posted in 1999

Kanwaljeet Grewal — Wed, 22 Dec 1999 13:04:17 -0000 — source: Informix-list mailing list archive (1991-1998)

In microsoft SQL, I can convert NULL values in Select statements to anything I want eg: ISNULL(Column1, "") - will convert NULL values in Column1 to empty strings. What I want to know is if there is a similar construct in Informix SQL. Cheers, Kan

↪ replying to Kanwaljeet Grewal

Madison Pruet — Wed, 22 Dec 1999 07:09:56 -0600 — source: Informix-list mailing list archive (1991-1998)

You should be able to use the SELECT col1, CASE ........... END FROM <table> to do this. Kanwaljeet Grewal wrote: > In microsoft SQL, I can convert NULL values in Select statements to anything > I want eg: > > ISNULL(Column1, "") - will convert NULL values in Column1 to empty strings. > > What I want to know is if there is a similar construct in Informix SQL. > > Cheers, > > Kan