http://blogs.technet.com/b/sqlman/archive/2010/01/05/tsql-tips-modifying-text-in-rows.aspxI have been doing some loading of random text in tables, but wanted to make changes to some of the text in rows, instead of running a full update operation, I discovered that you can also use TSQL functions REPLACE or STUFF to change text. Below are examplesen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/sqlman/archive/2010/01/05/tsql-tips-modifying-text-in-rows.aspx#3372605Thu, 02 Dec 2010 11:25:50 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3372605andrea<p>hi spawar,</p> <p>is better</p> <p>UPDATE Dbo.Table_1 </p> <p>SET c2 = REPLACE(c2,&#39;It&#39;,&#39;This&#39;) </p> <p>WHERE c1 = 1</p> <p>subquery is not required for this</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3372605" width="1" height="1">