Re: SPL string concatination

Hi , you can use || (pipes) to concatenate. It works with stored procedure. You can have a combination of constatns, variables, etc, in this.... let b = "world" let a = "hello " || trim(b) gives, a = "hello world" I am not sure about trim. That must be the actual key word or replace that with corresponding function. Good luck srini mlsrini@infogain.com In article <5sqh2s$kak@mtc1.mtcnet.net>, trayhons@dordt.edu (Travis Rayhons) wrote: > > > 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 -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to Usenet