title: Removing a digit from a number, Sql server
body: <p><strong>Table Employee:</strong></p>
  
  <pre><code>Id  Name  Salary
  --  ----  ------
  1   A1    120
  2   B1    105
  3   C1    200
  </code></pre>
  
  <p>Now I want to find the <strong>Sum of Salary</strong>, by removing the 0s in salary of each employee.</p>
  
  <p>i.e ; 12 + 15 + 2 = 29</p>
  
  <p>Any idea on how to achieve my result ? </p>
  
  <p>Thanks</p>