SET [column] = REPLACE([column], 'foo', 'bar')
SET [BranchName] = REPLACE([BranchName], 'SAMA', 'Sajjad Ahmed')
Posted by humrahimcs on February 6, 2014 in SQL Query
Tags: How to replace a string in a SQL Server Table Column, SQL replace query to substitute part of field data
Fill in your details below or click an icon to log in:
You are commenting using your WordPress.com account. ( Log Out / Change )
You are commenting using your Twitter account. ( Log Out / Change )
You are commenting using your Facebook account. ( Log Out / Change )
You are commenting using your Google+ account. ( Log Out / Change )
Connecting to %s
Notify me of new comments via email.
Blog at WordPress.com.
Entries (RSS) and Comments (RSS)