title: Remove leading zeros
body: <p>Given data in a column which look like this:</p>
  
  <pre><code>00001 00
  00026 00
  </code></pre>
  
  <p>I need to use SQL to remove anything after the space and all leading zeros from the values so that the final output will be:</p>
  
  <pre><code>1
  26
  </code></pre>
  
  <p>How can I best do this?</p>
  
  <p>Btw I'm using DB2</p>