title: SQL replace old values with new ones
body: <p>I have a table named <code>tbl.Products</code>, which has a column named <code>articlenumber</code> and is full of numbers like <code>s401</code>, <code>s402</code>, etc.</p>
  
  <p>I generated a list with new article numbers which will replace the old ones:</p>
  
  <pre><code>s401  I00010  
  s402  I00020  
  s403  I00030  
  s403  I00040  
  ...  
  </code></pre>
  
  <p>I have a query from which I hoped that it would work out, but somehow it does nothing.</p>
  
  <p>(of course I have nested the other values into the query)</p>
  
  <pre><code>SELECT REPLACE('articlenumber','s401','I00010') FROM tbl.Products
  </code></pre>
  
  <p>How do I get a query which replaces old values with new ones in a column like this?</p>