How to convert Varchar column to Numeric
<p>I have a requirement to move varchar column data to Numeric but with two conditions.</p>

<ol>
<li>All the alphanumeric value should migrate as null</li>
<li>All the decimal values should go as it is.</li>
</ol>

<p>I wrote the condition as <code>WHERE data like '%[^0-9]%'</code>, it is working fine for all the records except for decimal.</p>

<p>Also I have values like <code>.001 abcd</code>, this has to be pass as null.</p>

<p>To summarize I need : </p>

<pre><code>1) 1234 as 1234
2) 1.23 as 1.23
3) ABC as null
4) .ABC as null
</code></pre>