title: Error in converting value from char to money
body: <p>I have a table <code>tableA</code> that contains a column <code>[Amount]</code> of datatype <code>varchar</code>.</p>
  
  <p>It has values like:</p>
  
  <pre><code>47980.89
  333652.61
  332388.84
  374664.48
  368715.26
  371689.33
  371689.33
  368715.26
  374664.48 
  </code></pre>
  
  <p>Now when I run my query, it runs successfully but gives different output each time</p>
  
  <pre><code>SELECT  
     sum(convert(float, Amount))
  FROM tableA   
  </code></pre>
  
  <p>and when I try this other statement, I get an error </p>
  
  <blockquote>
    <p>Cannot convert a char value to money. The char value has incorrect syntax.</p>
  </blockquote>
  
  <p>Code:</p>
  
  <pre><code>SELECT  
      sum(convert(money, Amount))
  FROM tableA
  </code></pre>
  
  <p>I want to have sum of the column <code>[Amount]</code> </p>