0

I have data in TABLE A which contains something like below:

I had a doubt, which, was not confusing, so I needed help, hence I came, to StackOverflow, which cleared my doubt

Now I want the result to show the data between the 4th and 5th comma.

SO the answer would be hence I came

The string can be dynamic as well. I am not sure how to use CHARINDEX on this.

Can anyone help?

Muhammad Hannan
  • 2,389
  • 19
  • 28
Nirpeksh
  • 99
  • 2
  • 11
  • 1
    If the string is dynamic, how do you know which comma (4th and 5th) you have to use? Do you have more examples and the query which you have tried? – SK - Nov 17 '19 at 03:47
  • That's exactly what needs to be done , the query should dynamically find the fourth and fifth comma and give me the string between these two commas – Nirpeksh Nov 17 '19 at 03:48

0 Answers0