Re: Concatenation problem

Zeljan Silje wrote: > > Hi, > > 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. When I execute the following query: > select a || b > from t, > I get the following result: > A B > AAB, > and I would like to get: > AB > AAB. > > Is it possible to do? Yes and No. If you use Informix V7.x you can use select trim(a)||trim(b) ... However, I am not sure in which version exactly trim was introduced. It was not in 6.x definitely. Regards, Roland