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 |
|
mageshks
Yak Posting Veteran
59 Posts |
 Posted - 2009-03-25 : 09:28:45
|
| Hi All,I have a table like the followingcol1 col2 col3---------------------------------------------------testcol11 testcol12 somestring1testcol11 testcol12 somestring2Here the col1 and col2 values in the row 1 and row 2 are same.only col3 value is differenti want the o/p like the followingcol1 col2 col3---------------------------------------------------testcol11 testcol12 somestring1somestring2i want the col3 in row1 and row2 to be concatenatedThanks in advance |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
|
|
|
|
|
String Concatenation