Re: ISQL 4.1: String Concatenation

Posted in 1999

Jonathan Leffler — Thu, 25 Feb 1999 15:48:09 -0800 (PST) — source: Informix-list mailing list archive (1991-1998)

On Thu, 25 Feb 1999, David Forrest Tucker wrote: >Can you do string concatenation within the SQL script. Is there a >operator for strings that I do not know about? Given that you are using 4.1, the answer is No. The '||' operator was introduced in version 5. If your engine is a 5.x server, then you can use '||' in an SQL script -- they aren't parsed -- but not in ACE reports. Upgrading won't help much, either. When 7.30 is released (later this year), it will have support for '||' operators. Until then... Yours, Jonathan Leffler (jleffler@informix.com) #include <wish/I/was/skiing.h> Guardian of DBD::Informix v0.60 (v0.61_02) -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn