title: remove first character from mysql field
body: <p>I need advices in order to make a process on my list of values. I have a table <code>llx_societe</code> and some fields where one of them is <code>code_client</code>. This field looks like :</p>
  
  <pre><code>0099
  00100
  00101
  00102
  ...
  00998
  00999
  001000
  </code></pre>
  
  <p>I want to remove the first zero for all values between <code>00100</code> and <code>00999</code> in order to get <code>0100</code> until <code>0999</code>.</p>
  
  <p>I wrote this command :</p>
  
  <pre><code>UPDATE `llx_societe` 
  SET `code_client`= SUBSTR(code_client,1) 
  WHERE `code_client` BETWEEN '00100' AND '00999';
  </code></pre>
  
  <p>But nothing, none lines are proceed.</p>
  
  <p>Have you an explanation ?</p>