title: Issue converting string to decimal
body: <p>I am really tired with converting string to decimal in SQL Server.</p>
  
  <p>This is my query I am trying to convert to decimal</p>
  
  <pre><code>DECLARE @price VARCHAR(50)
  SET @price = '168,00'
  
  SELECT
      REPLACE(CAST(@price AS DECIMAL(29,2)), '.', ',')
  
  UPDATE MyTable 
  SET Invoice = REPLACE(CAST(@price AS DECIMAL(29,2)), '.', ',') 
  WHERE ID = 111
  </code></pre>
  
  <p>But I get this error:</p>
  
  <blockquote>
    <p>Msg 8114, Level 16, State 5, Line 7<br>
    Error converting data type varchar to numeric</p>
  </blockquote>
  
  <p>How can I get rid of this issue?</p>