title: How to replace a character from a String in SQL?
body: <p>I have 100's of cells in our database which contain <code>?</code> instead of <code>'</code>. It is possible that this might happen in all rows and columns and in more than one word per cell. Here is an example of just one cell. </p>
  
  <pre><code>Parents? CUI assumed equal to the sum of the father?s/stepfather?s and mother?s/ stepmother?s income .
  </code></pre>
  
  <p>I want to write an SQL statement which finds all the cells that contain <code>?</code> (may be more than one per cell)  and replace them with <code>'</code>. I am sure that all <code>?</code> have to be replaced without exception.</p>
  
  <p>I know there is a function replace but I couldn't know how to extract a character from a string in sql. </p>
  
  <p>This is one example I got but it couldn't help me.</p>
  
  <pre><code>UPDATE dbo.authors
  
  SET    city = replace(city, 'Salt', 'Olympic')
  WHERE  city LIKE 'Salt%';
  </code></pre>
  
  <p>Any ideas?</p>