title: How to select numeric value from nvarchar column in sql server?
body: <p>I have table like </p>
  
  <pre><code>Create table Producttbl ( sno nvarchar(100),sname nvarchar(200),price nvarchar(100))
  </code></pre>
  
  <p>Values are</p>
  
  <pre><code>sno    sname price
  1       aaa   1.50
  2       ccc   5.30 
  abc     xxx   abc
  3       dsd   kkk 
  nn      dss   5.1 
  </code></pre>
  
  <p>Price column is <code>nvarchar</code> it accept all kind of data like string or numeric. </p>
  
  <p>From that table, I want to select results like this:</p>
  
  <pre><code>   sno        sname  price
      1           aaa   1.50
      2           ccc   5.30
  </code></pre>
  
  <p>Please help me.</p>