Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Nylren
Starting Member
7 Posts |
 Posted - 2011-02-20 : 19:23:19
|
| Hi,I am lost here. Please help!!How can i make a select to join columns.House--------HouseIDAddressHow join all address into one column?The result would be a column with all address. Ex:Address--------Address1 + Address 2 + Address3 ...THANKS |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-02-20 : 21:33:46
|
Pretty much like that..SELECT Address1 + Address 2 + Address3 ... AS fulladdress
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
Join results in one row