Re: Concatenation problem

Jonathan Leffler wrote: } } On Thu, 4 Dec 1997, Zeljan Silje wrote: } } } I have table t with columns a (char(2)) and b (char(1)) with two rows } } like: } } a b } } A B } } AA B, } } } } I want to concatenate first and second column but without blank space } } among them. [...] Is it possible to do? } } Yes, if you have a sufficiently recent version of the engine. } } There's a TRIM function which could be used: } } SELECT TRIM(a) || TRIM(b) FROM t; } } I think this is a 7.2x function; it may or may not be in 7.1x. } } Yours, } Jonathan Leffler (johnl@informix.com) #include <witticism.h> it is valid for version 7.1x too! Vijay