title: How to update a part of the string using replace function in tsql?
body: <p>Hi
  I have a column of nvarchar(1000) type. I need to get rid of encode characters from that column and replace them with their special characters.
  For Example:</p>
  
  <pre><code>column value is : 'This text values contains this '&amp;amp;' this'.
  </code></pre>
  
  <p>I have to replace <code>'&amp;amp;'</code> with '&amp;'.</p>
  
  <ol>
  <li>First have to find the record which has <code>'&amp;amp;'</code> in the column (may be using like condition)</li>
  <li>And then replace only this word with its special character</li>
  </ol>
  
  <p>How do i do that? Pl. help</p>