title: How to convert Exist data from nvarchar to float in SQL Server
body: <p>I have a table <code>Overseas</code> in SQL Server take its data from an Excel sheet so numbers data sometimes is converted to text. I want to perform an analysis so I have to convert this text to float each time I load this Excel file.</p>
  
  <p>I created another table with datatype <code>float</code> to copy the same table data to make analysis easier.</p>
  
  <p>I tried this command; it works but the existing data doesn't get changed</p>
  
  <pre><code>SELECT 
      CONVERT(FLOAT, REPLACE([SalesValue],',','') )[SalesValue]
  FROM 
      Overseas
  </code></pre>
  
  <p>sql table </p>
  
  <p><a href="https://i.stack.imgur.com/hXkzV.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hXkzV.jpg" alt="enter image description here"></a></p>
  
  <p>For example : <code>SalesValue</code> column is <code>nvarchar</code> i want to convert it to <code>float</code> and the data existing converted from <code>nvarchar</code> to <code>float</code> .. i want the output like this</p>
  
  <p><a href="https://i.stack.imgur.com/ARqNo.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ARqNo.jpg" alt="enter image description here"></a></p>
  
  <p>Any help or another easier way ?</p>