Concatenation problem
Posted in 1997
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 | +--------------------------+-----------------------------+