title: SQL update, string to numeric
body: <p>In an SQL Server database, I have to update some fields, the query is (, is the decimal separator) :</p>
  
  <pre><code>UPDATE MyTbable 
  SET 
  Field1 =   CAST('111,11' AS DEC(18,4)),
  Field2 =  CAST('222,22' AS DEC(18,4)),
  Field3 =  CAST('333,33' AS DEC(18,4))
  WHERE Id = '1'
  </code></pre>
  
  <p>I receive the error :
  <em>Error converting data type varchar to numeric.</em> I tried with the cast, same problem</p>
  
  <p>Field1,Field2 and Field3 are numeric 38,2</p>
  
  <p>Any idea ?</p>
  
  <p>Thanks,</p>