title: I have a string of SQL with different amounts. How do I add them together. NET?
body: <p>I have the folowing SQL query:</p>
  
  <pre><code>SELECT * from sales WHERE cdate = (SELECT CONVERT(char(11), GETDATE(),20)) 
  </code></pre>
  
  <p>With this result:</p>
  
  <pre>
  <b>ID  NO      DATE                    AMOUNT</b>
  
  9   103100  2012-01-31 00:00:00.000 44.29
  
  10  110150  2012-01-31 00:00:00.000 2360.93
  
  11  114000  2012-01-31 00:00:00.000 63.60
  
  12  217155  2012-01-31 00:00:00.000 717.27
  </pre>
  
  <p>How can I add the values in the last column (<code>amount</code>)?</p>