Re: Unable to concatenate a string to a column

> > > I'm using Informix-OnLine 4.10, and if I try to concatenate a character column > with a string, eg > > SELECT column1 || "a text string" FROM table1; > > the statement is rejected with: > > 202: An illegal character has been found in the statement.> > Is concatenation only supported in later versions of Informix? > > > -- > Keith Davies > > Internet: keith@keithd.demon.co.uk > Tel.: +44 582 833651 > > The short answer is yes. It is the engine that either supports or doesn't support this feature. I have SE 5.00 using ISQL 4.00, the above feature works well. I also have OnLine 5.0x on SunOS 4.1.3 using ISQL 4 and it works fine. There are other nice features of the 5.00 engine: It supports many other math functions, like SQRT, TAN, SIN, etc., which 4 does not. See a previous thread. My suggestion is to upgrade. It's worth it. ========================================================================== == George Teachman == == Soil Scientist == == United States Department of Agriculture - Soil Conservation Service == == Fort Collins, Colorado == == 303-282-1960 == == == == george@talon.ftc.scs.ag.gov == == ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ == == Welcome to earth, third rock from the sun. Cause and effect. == == There are only three laws of nature, and one exception. == == 1) F=ma; 2) E=m(c squared); 3) You can't push a rope == == From these three laws all others can be derived. == == Except those explained by CHAOS THEORY. == ==========================================================================