title: How to convert Varchar column to Numeric
body: <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>