This function returns the value indicated in a string separated by a character in particular, like a split function in Visual basic.
Note: 1st value in string is 0.
Ex. 1:
SET @Result='1~Example Text~5'
EXEC SplitString1 @yourString = @Result,@Delimiter = '~',@ReturnVal =0, @Result = @Result OUTPUT
SELECT @Result as Result
Returned Value='1'
Ex 2:
SET @Result='Value1~Value2~Value3~Value4'
EXEC SplitString1 @yourString = @Result,@Delimiter = '~',@ReturnVal =2, @Result = @Result OUTPUT
SELECT @Result as Result
Returned Value='Value3'
