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 |
|
smd978
Starting Member
3 Posts |
 Posted - 2008-10-23 : 13:43:01
|
| Hi,I have a column which needs to be updated by appending a set of characters ("123") to the end of that value. How would I accomplish this? Thanks. |
|
|
smd978
Starting Member
3 Posts |
Posted - 2008-10-23 : 13:44:48
|
| Just to clarify, I would like to update ALL the values in that column. |
 |
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2008-10-23 : 13:51:21
|
| update tab1set col1 = col1+'123' |
|
|
|
smd978
Starting Member
3 Posts |
Posted - 2008-10-23 : 14:04:07
|
| So simple...Works like a charm! Thanks! |
|
|
|
|
|
|
Appending characters to all values in a column