title: SQL Server : Replace (Charindex)
body: <p>I have a SQL Server table with numbers in column <code>no</code>: </p>
  
  <pre><code>12345670000115 
  14245670000116 
  58492010000118 
  </code></pre>
  
  <p>I need a function that will remove one number <code>1</code> from right side of number, so result must be like: </p>
  
  <pre><code>1234567000015 
  1424567000016 
  5849201000018 
  </code></pre>
  
  <p>I find some solutions to use <code>charindex()</code> with <code>substring()</code>, but my SQL skills are poor so I really need help.</p>
  
  <p>Thanks</p>