Re: Concatenation problem

Hi Zeljan, Try select trim(a) || trim(b) from t /ravi ---Zeljan Silje <zeljan@laus.hr> 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? } } Thanks in advance. } } +--------------------------------------------------------+ } | CC Computer Consulting d.o.o. | } +--------------------------+-----------------------------+ } | Zeljan Silje | e-mail: zeljan@laus.hr | } | CC Computer Consulting | Tel: +385 (20) 411-136 | } | Janjevska 15 | +385 (1) 6552-330 | } | 20 000 Dubrovnik | Fax: +385 (20) 411-136 | } | Hrvatska (Croatia) | URL: http://www.laus.hr | } +--------------------------+-----------------------------+ } == Ravi Joseph Pinto, Senior Consultant, Astra Infotech Ltd, Mumbai, India. email : rjpinto@bigfoot.com Last seen in cool London _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com