Re: Concatenation (Building a string)

Nick When you say "Does not work" do you mean that you cant see strDetail and strDiary in strDetail (in your example #2)? In that case your strDetail is probably not large enough to hold both strings. Informix does not strip off trailing blanks by default, so you would need to do: LET strDetail = TRIM(strDetail) || TRIM(strDiary); HTH Sujit nanson@paulweiss.com on 03/04/99 01:01:09 PM To: informix-list@iiug.org cc: (bcc: Sujit Pal) 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. ___________________________________________________