-
Extracting data from a table
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|