Oninit cdi / Archive
Talk to an expert →

string append

Posted in 2008

Topics: General Discussion

monkeys paw — — source: Usenet: comp.databases.informix

I am appending two strings thusly, define source char(20), addon char(20) let source = source, addon Do i need to do a trim on the source string during the let statement?

↪ replying to monkeys paw
Everett Mills — — source: Usenet: comp.databases.informix

If you want source "I am a string, " + addon "too" to look like this: "I am a string,too", use this: LET source = source CLIPPED, addon If you want "I am a string, too ", use this: LET source = source CLIPPED, " ", addon --EEM > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of monkeys paw > Sent: Wednesday, October 15, 2008 4:01 PM > To: informix-list@iiug.org > Subject: string append > > I am appending two strings thusly, > > define > source char(20), > addon char(20) > > let source = source, addon > > Do i need to do a trim on the source string during the let statement? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list

↪ replying to monkeys paw
Obnoxio The Clown — — source: Usenet: comp.databases.informix

monkeys paw said: > I am appending two strings thusly, > > define > source char(20), > addon char(20) > > let source = source, addon > > Do i need to do a trim on the source string during the let statement? It depends. HTH. -- Bye now, Obnoxio http://obotheclown.blogspot.com/

↪ replying to monkeys paw
Mike Aubury — — source: Usenet: comp.databases.informix

Yes... In 4GL - the keyword you are looking for is probably 'CLIPPED'... On Wednesday 15 October 2008 22:01:10 monkeys paw wrote: > I am appending two strings thusly, > > define > source char(20), > addon char(20) > > let source = source, addon > > Do i need to do a trim on the source string during the let statement? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list -- Mike Aubury http://www.aubit.com/ Aubit Computing Ltd is registered in England and Wales, Number: 3112827 Registered Address : Clayton House,59 Piccadilly,Manchester,M1 2AQ

↪ replying to Everett Mills
monkeys paw — — source: Usenet: comp.databases.informix

Thank you, i had forgotten the "clipped" function. > If you want source "I am a string, " + addon "too" to look like > this: "I am a string,too", use this: > > LET source = source CLIPPED, addon > > If you want "I am a string, too ", use this: > > LET source = source CLIPPED, " ", addon > > --EEM > >> -----Original Message----- >> From: informix-list-bounces@iiug.org [mailto:informix-list- >> bounces@iiug.org] On Behalf Of monkeys paw >> Sent: Wednesday, October 15, 2008 4:01 PM >> To: informix-list@iiug.org >> Subject: string append >> >> I am appending two strings thusly, >> >> define >> source char(20), >> addon char(20) >> >> let source = source, addon >> >> Do i need to do a trim on the source string during the let statement? >> _______________________________________________ >> Informix-list mailing list >> Informix-list@iiug.org >> http://www.iiug.org/mailman/listinfo/informix-list