Re: Concatenation problem

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>