RE: Concatenation (Building a string)

Posted in 1999

mosserp@WellsFargo.COM — Thu, 4 Mar 1999 13:11:43 -0800 — source: Informix-list mailing list archive (1991-1998)

Try: strDetail = trim(strDetail) || strDiary ================================ Paul A. Mosser, Open Systems DBA Informix Certified DBSA Wells Fargo & Co. Tempe, Arizona paul.mosser@wellsfargo.com ================================ > -----Original Message----- > From: nanson@paulweiss.com [mailto:nanson@paulweiss.com] > Sent: Thursday, March 04, 1999 2:01 PM > To: informix-list@iiug.org > Subject: Concatenation (Building a string) > > > I'm trying to build a string inside a stored procedure in a > FOR EACH loop. > Can someone explain the behavior of the following: > > strDetail = strDiary This works > > strDetail = strDetail || strDiary This doesn't work? > > strDetail = "MyText" || strDiary This works > > strDetail = strDiary || "MyText" This doesn't work? > > > Sorry... VB programmer, not an Informix guy. > > Nick > > > > > __________________________________________________ > > This message is intended only for the use of the Addressee and may > contain information that is PRIVILEGED and CONFIDENTIAL. > > If you are not the intended recipient, you are hereby > notified that any > dissemination of this communication is strictly prohibited. > If you have > received this communication in error, please erase all copies of the > message and its attachments and notify us immediately. > > Thank You. > ___________________________________________________ > >