title: How to trim the column in DB2
body: <p>How to trim the column in DB2 for the below given input<br></p>
  
  <p><code>00652835065718</code><br>
  <code>00052835065718</code></p>
  
  <p>I need to use SQL to remove all leading zeros from the values so that the final output will be:<br></p>
  
  <p>652835065718<br>
  52835065718<br></p>
  
  <p>The Column is VARCHAR </p>
  
  <p>I have tried the below query</p>
  
  <pre><code>select TRIM(L '0' FROM ID) from ITM where ID = '0652835065718'
  </code></pre>
  
  <p>but it's not working in my DB2 version <code>9.1.5</code></p>