title: T-SQL how to SUM a text data?
body: <p>I got a field value <code>0+6+6+6+0+0+0</code> data type is varchar. how can I get sum of it. </p>
  
  <p>I have tried to convert to int but I got error.</p>
  
  <pre><code>select cast('0+6+6+6+0+0+0' as int)
  </code></pre>
  
  <p>I want output as <code>18</code>.</p>