title: SQL : Error converting data type nvarchar to float
body: <p>I want to convert <code>nvarchar</code> data to <code>float</code> type.</p>
  
  <p>In my case I have <code>SalesValue</code> column and I used this command </p>
  
  <pre><code>UPDATE Overseas 
  SET SalesValue = CONVERT(FLOAT, REPLACE([SalesValue],',','') )
  </code></pre>
  
  <p>My table has values like</p>
  
  <pre><code>201.01
  40.50
  215.12
  550
  304.201
  </code></pre>
  
  <p>But I get an error </p>
  
  <blockquote>
    <p>SQL : Error converting data type nvarchar to float.</p>
  </blockquote>
  
  <p>How can I solve this problem ?</p>