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 |
|
gurvanov
Starting Member
5 Posts |
 Posted - 2005-04-21 : 06:59:44
|
| Hi,if i have a table with 3 rows, let's say adress, name and surname,is it possible to make such a selection, that as a result only two rows are listed, but in fact the 2nd and the 3rd are merged together, for example:address -----------------name-----------------------------------US......-------------John Smith |
|
|
Amethystium
Aged Yak Warrior
701 Posts |
Posted - 2005-04-21 : 07:09:00
|
[code]select address, name + ' ' + surname as 'FullName'from yourTable[/code]------------->>> BREAKING NEWS!!! <<<------------- Saddam Hussien has weapons of mass destruction |
 |
|
|
gurvanov
Starting Member
5 Posts |
Posted - 2005-04-21 : 07:12:59
|
| super, thanks :) |
|
|
|
|
|
|
select