title: Hibernate query to remove leading zeros
body: <p>I want to do :</p>
  
  <pre><code> select * from accounts where account_number = '234567'
  </code></pre>
  
  <p>User can enter on the GUI as account number = '234567' but database column could have the value of '0000234567' . Still it should match.</p>
  
  <p>Can this SQL query work ? </p>
  
  <pre><code>select * from accounts a where 
  (:accountNumber LIKE (TRIM(REPLACE((a.account_number), '0', '%'))))
  </code></pre>