Re: Null in string concatenation

Posted in 1998

Manuel A. Daponte Santiago — Sun, 29 Nov 1998 01:01:29 -0400 — source: Informix-list mailing list archive (1991-1998)

This is a multi-part message in MIME format. --------------4F6B43A9992FBC42A03B3749 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit If you have IDS 7.3 you can use the nvl function select nvl(a.last, " ") || ', ' || nvl(a.first, " ") From a "Gabbard, Mike W." wrote: > 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. --------------4F6B43A9992FBC42A03B3749 Content-Type: text/x-vcard; charset=us-ascii; name="mdaponte.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Manuel A. Daponte Santiago Content-Disposition: attachment; filename="mdaponte.vcf" begin:vcard n:Daponte Santiago;Manuel Andres x-mozilla-html:FALSE org:GM Group Inc. version:2.1 email;internet:mdaponte@prtc.net title:Systems Consultant note:ICQ 12214968 adr;quoted-printable:;;MSC #54, Montehiedra Town Center=0D=0A9410 Los Romeros Ave.;San Juan;PR;00926;USA x-mozilla-cpt:;0 tel;home:+1 (787) 2921107 tel;work:+1 (787) 7514343 fn:Manuel Andres Daponte Santiago end:vcard --------------4F6B43A9992FBC42A03B3749--