Re: ISQL - concat problem

Posted in 1995

Gabriel Beccar-Varela — 15 Jul 1995 15:42:26 GMT — source: Informix-list mailing list archive (1991-1998)

peterog@interaccess.com wrote: >example: >declare row1 char30 >declare row2 char30 >declare accum char60 > >let accum= accum || row1 -- works ok, except accum contains 60 bytes >let accum = accum || row2 -- ignores row2 value > >I tried using a length function >let x = length(row1) >let y = length(row2) >let accum= accum || row1[1, x] -- doesn't work, appears you can not use a variable within the []'s?? >let accum = accum || row2[1, y] > >Any help would be appreciated. > > clip the strings before concatenating the new one: let accum = accum CLIPPED || rwo1 The CLIPPED function gets rid of the extra padding. -- Gabriel Beccar-Varela E-Mail gabriel@emf.net