combining columns

[maesb]

Hi..

I'm trying to query a few columns from my table, but i would like it to return those few columns as one. my table looks something like this :

add1 add2 add3
Unit 101 East Malvern Caulfield

i want to select add1, add2 and add3 as address, with a comma as a deliminator. so the output for that query will be:

Unit 101,East Malvern,Caulfield

is that possible? thanks.

 

[JtheRipper]

Hi,

Try:

select add1||', '||add2||', '||add3 AS "NEW COLUMN NAME"
from mytable;

J.

 

[maesb]

why didn't i think of that? lol.. thanks a lot.