title: How to replace nth character in sql server
body: <p>I am trying to replace the nth character in SQL Server. I tried with it using <code>replace()</code>:</p>
  
  <pre><code>SELECT REPLACE(ABC,0,1)  FROM XXX
  </code></pre>
  
  <p>In above code all zeros will be replaced with one, but I only want to change it in a particular position and sometimes that position can change.</p>