title: How to return only numerical values, in ascending order
body: <p><strong>How to get record in ascending order</strong></p>
  
  <p>My data is </p>
  
  <pre><code>101    
  102    
  w    
  200    
  11        
  NO        
  131        
  2        
  XYZ
  </code></pre>
  
  <p>And I only want to return numbers, in ascending order.
  Datatype is <code>varchar</code></p>
  
  <p>I want to write query as :</p>
  
  <pre><code>SELECT rno FROM  ml_entry 
  WHERE (rno NOT LIKE '%[a-z]%') 
  ORDER BY rno
  </code></pre>
  
  <p>The above SQL creates the below output:</p>
  
  <pre><code>101
  102
  11
  131
  154
  2
  </code></pre>
  
  <p>But this is the output I want:</p>
  
  <pre><code>2
  11
  101
  102
  131
  154
  </code></pre>
  
  <p>Any advice?</p>