title: SQL Server find and replace specific word in all rows of specific column
body: <p>I have a table <code>TblKit</code> that has columns <code>Id</code> and <code>Number</code>. <code>Id</code> is <code>primary key</code> of type <code>int</code> and <code>Number</code> is <code>varchar(50)</code>.</p>
  <p>The data in the table looks like this:</p>
  <pre><code>Id     Number
  ---    ------
  1      KIT001
  2      KIT002 
  3      DMB001
  4      DM002
  5      KIT003
  </code></pre>
  <p>I want to replace all the rows of <code>KIT%</code> with <code>CH</code> in the Number field. The desired output would look like:</p>
  <pre><code>Id     Number
  ---    ------
  1      CH001
  2      CH002 
  3      DMB001
  4      DM002
  5      CH003
  </code></pre>
  <p>I have tried this update query:</p>
  <pre><code>UPDATE TblKit SET Number = REPLACE(Number, N'%KIT%', 'CH') 
  </code></pre>
  <p>But it is not working.</p>
  <p>Can anyone help me regarding this?</p>