Re: SPL string concatination

Travis Rayhons wrote: }>From ilist@rmy.emory.edu Tue Aug 12 17:30:43 1997 }>Received: from rmy.rmy.emory.edu (rmy.rmy.emory.edu [170.140.97.4]) }> by hobbes.dbintellect.com (8.8.6/8.8.6) with ESMTP id RAA17510 }> for <settler@dbintellect.com>; Tue, 12 Aug 1997 17:30:42 -0600 (MDT) }>Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id RAA10538 for informix-list-out; Tue, 12 Aug 1997 17:25:01 -0400 (EDT) }>From: trayhons@dordt.edu (Travis Rayhons) }>Message-Id: <5sqh2s$kak@mtc1.mtcnet.net> }>Subject: SPL string concatination }>Date: 12 Aug 1997 20:29:16 GMT }>Reply-To: trayhons@dordt.edu (Travis Rayhons) }>Organization: Dordt College, Sioux Center, IA }>Sender: informix-list-owner@rmy.emory.edu }>To: informix-list@rmy.emory.edu }>X-Informix-List-Id: <news.41558> }> }> }>I am running Informix-Online Dynamic Server, Version 7.2, and having }>difficulty doing string concatination in stored procedures. My first }>attempt was to use the same syntax as 4GL (the comma), but then learned }>by reading the manuals that I was trying to assign to multiple variables. }> }>I am trying to do something similar to below: }> DEFINE string CHAR(40); }> }> LET string = "This", " string." }> }>Does anyone have any idea on how to do this in SPL? }> }>I do have a solution to send the important information to a 4GL program, }>but I hate to slow down the stored procedure any more by calling other }>programs. }>--- }>Travis Rayhons trayhons@dordt.edu }>Dordt College Computer Services (712) 722-6299 (w) }>Programmer/Systems Administrator }> Use this syntax: LET string = "This" || "string"; ------------------------------------------------------------------- Jeff Craig | dbINTELLECT Technologies, Inc. Senior Consultant | Golden, CO | (303) 275-6954 ext. 8008 | email: settler@dbintellect.com | fax: (303) 275-2134 -------------------------------------------------------------------