SQL to UPDATE and REPLACE part of a string

If you have a table with one field as string and you want to replace a part of string in all rows then use this query

UPDATE dbo.xxx  SET Value = REPLACE(Value, '123\', '456')  WHERE ID <=4

​Here dbo.xxx is the name of table and value is the column which ​you want to replace. In this case, it will replace all 123 with 456.

I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too. 

Stay tuned to my blog, twitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will not share your email address to anybody as we respect privacy.