title: How to sum numbers in a delimited string using SQL Server
body: <p>I have a string containing numbers delimited by a pipe like so <code>23|12|12|32|43</code>. </p>
  
  <p>Using SQL I want to extract each number, add 10 and then sum to get a total. </p>