Re: SILLY SQL QUESTION

Posted in 1995

Dennis Pimple — 6 Apr 1995 16:54:08 GMT — source: Informix-list mailing list archive (1991-1998)

Stuart Hemming (shemminga@cix.compulink.co.uk) wrote: : I know this sounds daft but is it possible to cat 2 strings together as : part of an SQL statement? If you mean 2 column values in a table, double pipe the two values: SELECT col1 || col2 ... Beware that CLIPPED gets tricky (or impossible) unless you have an engine version (7.0?) that supports trim(), so you get col1 padded with spaces to its full length, then col2. ======================================================================= Dennis J. Pimple dennisp@informix.com Opinions expressed Senior Consultant -------------------- are mine, and do not Informix Software Inc Voice: 303-850-0210 necessarily reflect Denver Colorado USA Fax: 303-779-4025 those of my employer.