If that format is fixed 'Value1$Value2$Value3', then you don't need any other user-defined functionsDECLARE @P_DSVParam VARCHAR(1000) = 'Data$72,40$123428171,524568179' -- Input Param for passing Delimiter separated valuesDECLARE @V_Value2 VARCHAR(100), @V_Value3 VARCHAR(100), @startPos INT, @EndPos INTSELECT @startPos= CHARINDEX('$', @P_DSVParam), @EndPos = CHARINDEX('$', REVERSE(@P_DSVParam))SELECT @V_Value2 = SUBSTRING( @P_DSVParam, @startPos+1, LEN(@P_DSVParam)-(@endPos+@startPos) ), @V_Value3 = RIGHT( @P_DSVParam, @EndPos-1)SELECT @V_Value2, @V_Value3
Tell us the purpose of SP... we can try in another way...