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 |
|
stahorse
Yak Posting Veteran
86 Posts |
 Posted - 2012-08-31 : 03:03:04
|
| I have this tableCSN NAME LOCATION TYPEMO-550 IFA Comapny MO-450 SIPP1-275 BGT Company NN-SP Company1-2956 BLQ Company SSFT TRUSTHow do i write a query that return a NAME concatenated with it's CSN |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-31 : 10:19:38
|
do you mean this?SELECT CSN + ' ' + NAME AS ConcatValue,*FROM table ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
concatenate value