Loading

How to get comma seperated stringtill 3rd comma

Khargesh Rajput

12y1.4k

How to Get Comma separated string
I have more then 3 comma in string and i want to slect only string 3rd string using sql queryy
plz help
I dont want to use c sharp

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Ashok Karale12y ago
try something like select SUBSTRING (@s, CHARINDEX(',',@s,CHARINDEX(',',@s)+1)+1, CHARINDEX(',',@s,CHARINDEX(',',@s,CHARINDEX(',',@s)+1)+1) -CHARINDEX(',',@s,CHARINDEX(',',@s)+1)-1)
0