Removing a digit from a number, Sql server
<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>