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.

SQL 2008r2

```
Details Column String: ex
Request to prepare method. Context: Site: | Factory: | Unite ID: | Batch ID:0000123456 | Product Name: |

```

Any thoughts on an approach? e.g Inner Join/Parse function