Dear all, I have a table which has a column that contains data like '
'654:JT12;678:JT56;'
It is sometimes more or less but it is always in the pattern shown
I am trying to extract the item between the ';' and the ':'
(In other words, I am trying to extract 'JT12' and 'JT56' and store it in another table).
Can anyone be kind enough to help me out? I tried Patindex and substring but I can't seem to be able to construct a usable function that will strip out what I need

Any help will be highly appreciated
Nneka