Remove zeros between a number SQL
<p>Is there a way to remove zeroes from a string using plain SQL?
I used the <code>trim</code> or <code>substring</code> function for the query.</p>
<p>Input:  <code>60400</code><br />
Output: <code>64</code></p>
<p>The following SQL only removes the leading zeros from the number.</p>
<pre><code>select amount, to_char(trim(0 from amount)) as new_amount from my_deductions;
</code></pre>