How to get comma seperated stringtill 3rd comma

Question

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

Answer 1

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)