title: Replace Last character in SQL Server 2008
body: <p>I am working with SQL server 2008, and facing problem about character replacement.</p>
  
  <p>If I use</p>
  
  <pre><code>SELECT REPLACE(MYWORD,0,1) FROM MYTABLE
  </code></pre>
  
  <p>It is replacing all 0 into 1, I just want to replace Last character Like <code>MYWORD = "ERMN0"</code> so it will be <code>MYWORD = "ERMN1"</code></p>