RE: Null in string concatenation

Posted in 1998

Gabbard, Mike W. — Thu, 19 Nov 1998 15:36:15 -0600 — source: Informix-list mailing list archive (1991-1998)

If you update all nulls to a single space " ", that is one way to get the select to work. -----Original Message----- From: Rafal Furdzik [mailto:rfurdzik@paulweiss.com] Sent: Friday, November 13, 1998 12:09 PM To: informix-list@iiug.org Subject: Null in string concatenation If a.first is null,this select will return nulll Select a.last || ', ' || a.first From a How to return a.last only in case if a.first is null. Please help.