title: SQL Server 2008 varchar to decimal results in: "Error converting data type varchar to numeric"
body: <p>I am trying to store a value stored as a varchar in a decimal field.</p>
  
  <p>The following examples all results in: "Error converting data type varchar to numeric."</p>
  
  <p>what am i missing here ?</p>
  
  <pre><code>SELECT CONVERT(decimal(11,2), '6.999,50') 
  SELECT CONVERT(decimal(11, 2), '6.999,50')
  SELECT CAST('6.999,50' AS decimal) / 100.0
  SELECT CAST((CAST('6.999,50' AS decimal) / 100000) AS decimal(17,5))
  </code></pre>