title: SQL server : Error converting data type varchar to float
body: <p>SQL Server : i want to convert my varchar datatype to float but i do have some scientific notation values in it(for ex. 3.11955748130297E-02) and i am getting following error : Error converting data type varchar to float.</p>
  
  <p>I have tried it using convert and cast functions, but that's not working.</p>
  
  <pre><code>insert into table1--(data type as float) 
  
  select convert(float,column1),-- contains '3.11955748130297E-02' as value and datatype is varchar 
  
  convert(float,column2) 
  
  from table2
  </code></pre>