title: How to do an EVAL expression in SQL
body: <p>I have a table with a column that has numbers separated by commas. I want to add all the numbers together for each record. Using the <em>spexecuteSQL</em> I have got this far, but it's still not evaluating the field. How do I do it?</p>
  
  <p><strong>eg.</strong> field is '4,5,5' transpose to 4+5+5 but want to evaluate and get ---> 14</p>
  
  <pre><code>declare @com as nvarchar(100)
  set @com= 'select replace(class_historyTY,'','',''+'') from #aety1'
  
  exec sp_executesql @com
  </code></pre>