title: SQL to remove Zero's in the string in MYSQL
body: <p>SQL to remove Zero's in the string for a particular column.  I am tried using the REPLACE but it is completing removing all the 0's</p>
  
  <p>EXAMPLE: "(REPLACE(Column,'0','')" But that didn't solved my problem.  It removed all the Zero's which is not the requirement.</p>
  
  <p>Can some one help me in writing the SQL statement to remove only 1st zero from the string.</p>
  
  <p>Column</p>
  
  <p>00-01-09</p>
  
  <p>07-00-02</p>
  
  <p>03-04-00</p>
  
  <p>03-04-06</p>
  
  <hr>
  
  <p>Result</p>
  
  <p>0-1-9</p>
  
  <p>7-0-2</p>
  
  <p>3-4-0</p>
  
  <p>3-4-6</p>
  
  <p>Thank you </p>