title: Sql Server Split and Concatenation
body: <p>I have data in the following format in a sql server database table</p>
  
  <pre><code>[CPOID]  [ContractPO]        [ContractPOTitle]
  1        10-SUP-CN-CNP-0001  Drytech
  2        10-SUP-CN-CNP-0002  EC&amp;M
  </code></pre>
  
  <p>I need to write a stored procedure to generate the following result</p>
  
  <pre><code>[CPOID]      [ContractPO]        [ContractPOTitle]   [ConcatField]
      1        10-SUP-CN-CNP-0001  Drytech            CNP-0001-Drytech            
      2        10-SUP-CN-CNP-0002  EC&amp;M               CNP-0002-EC&amp;M
  </code></pre>
  
  <p>where [ConcatField] generate the result using split the last two values of the [ContractPOTitle] column and combine with the [ContractPOTitle]</p>