trim value in sql where condition
<p>I have a row of records in my db <code>abc</code> table, col1 has value '00012345'.</p>

<p>requirement: '00012345' is equal to '12345', trim all the '0' in front.</p>

<p>Here is my sql query:</p>

<pre><code>SELECT * FROM abc WHERE col1 = '12345';
</code></pre>

<p>This query will not return me any result, unless I change it to </p>

<pre><code>SELECT * FROM abc WHERE col1 LIKE '%12345';
</code></pre>

<p>But this will break the rules, for example if my value in db is '00912345',
then '00912345' is not equal to '12345' after trim all the '0' in front.</p>

<p>Kindly advise on how to trim the value in db as well when doing comparison.</p>