title: Sum of data in varchar column
body: <p>i have to sum element in a column(SCENARIO1) that is varchar and contain data like (1,920, 270.00, 0, NULL) but when i try to convert data into int or decimal i get this error : 
  "he command is wrong when converting value "4582014,00" to int type"</p>
  
  <p>here is my request : </p>
  
  <pre><code>select sum( convert( int, SCENARIO1) )
  from Mnt_Scenario_Exercice where code_pere='00000000'
  </code></pre>
  
  <p>any help please</p>