title: Parsing Delimited Data and Matching Single Value
body: <p>Currently I have column (Details) which is a delimited string. I require the ability to parse and match Batch ID value against CX.STRING_4 (batch ID) value from another table.</p>
  
  <p>SQL 2008r2</p>
  
  <pre><code>Details Column String: ex
  Request to prepare method. Context: Site: | Factory: | Unite ID: | Batch ID:0000123456 | Product Name: |
  </code></pre>
  
  <p>Any thoughts on an approach? e.g Inner Join/Parse function</p>