title: sql like operator to get the numbers only
body: <p>This is I think a simple problem but not getting the solution yet. I would like to get the valid numbers only from a column as explained here.</p>
  
  <p>Lets say we have a varchar column with following values</p>
  
  <pre><code>ABC
  Italy
  Apple
  234.62
  2:234:43:22
  France
  6435.23
  2
  Lions
  </code></pre>
  
  <p>Here the problem is to select numbers only </p>
  
  <p><code>select * from tbl where answer like '%[0-9]%'</code>  would have done it but it returns </p>
  
  <pre><code>    234.62
      2:234:43:22
      6435.23
      2
  </code></pre>
  
  <p>Here, obviously, 2:234:43:22 is not desired as it is not valid number.</p>
  
  <p>The desired result is</p>
  
  <pre><code>        234.62
          6435.23
          2
  </code></pre>
  
  <p>Is there a way to do this? </p>