title: SQL Server: Error converting data type varchar to float with Comma as Decimal point
body: <p>I stored the values in W10Pro and the decimal values (varchar(50)) cannot be casted to float, I doubt the comma cannot be separated such that commands</p>
  
  <pre><code>SELECT CAST('27,18' as float) 
  
  SELECT CONVERT(float, '27,18')
  </code></pre>
  
  <p>fire an error <code>Error converting data type varchar to float</code>. How can I fix this?</p>