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 |
|
New IT Guy
Starting Member
2 Posts |
 Posted - 2008-01-14 : 16:38:46
|
| I have a table and that I need to update one column by add to the front of each row.As an example I currently has "Mydata" I want to add 2008 to all rows to show "2008Mydata". How do I add these 4 characters to the front of each row.Thank you! |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-01-14 : 16:45:31
|
Assuming the data you wish to do this to is a text or varchar field..Update [Table]Set [Column] = '2008' + [Column]
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
New IT Guy
Starting Member
2 Posts |
Posted - 2008-01-15 : 15:04:26
|
| THANKS VERY MUCH THAT WAS IT! |
|
|
|
|
|
|
Add to current Data