Am Mon, 2003-07-07 um 21.04 schrieb phil campaigne:
> Hi All,
> Can I combine 2 columns as a single column in a select statement?
> i.e. select value_1, value_2, (value_2 + value_2) from table;
Concatenating 2 Strings is done with ||
SELECT 'foo' || ' bar';
'foo bar'
The result is simply 1 string, ie. you can handle it like any other
column.
HTH
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de