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

Ashok Karale · Answer

try something like select SUBSTRING (@s CHARINDEX(''@sCHARINDEX(''@s)+1)+1 CHARINDEX(''@sCHARINDEX(''@sCHARINDEX(''@s)+1)+1) -CHARINDEX(''@sCHARINDEX(''@s)+1)-1)