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 |
|
Limuh
Yak Posting Veteran
94 Posts |
 Posted - 2011-05-18 : 23:35:32
|
| Hi,Is there any way to update a data having the same values.For exampleColumn A-------I:\Test\2107_Boom\AccentureNGA\xslt\Letter1.xsltI:\Test\2107_Boom\AccentureNGA\xslt\Letter2.xsltI:\Test\2107_Boom\AccentureNGA\xslt\Letter3.xsltI want to update the record that having I:\Test\ to D:\Testing is there any way that i can do it on one update statement aside from doing the update per record?Thank you for the help. |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2011-05-19 : 00:07:30
|
| update tset ColumnA = replace(ColumnA, 'I:\Test\', 'D:\Testing\') -- assume you want trailing slash therefrom YourTable as [t]--where ColumnA like 'I:\Test\%' --? |
 |
|
|
Limuh
Yak Posting Veteran
94 Posts |
Posted - 2011-05-19 : 01:47:31
|
| Thank you nathans, this is very helpful.. |
|
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2011-05-19 : 12:12:28
|
| anytime. |
|
|
|
|
|
|
Update Certain Data in a column