fnGetVal

ALTER FUNCTION [dbo].[fnGetVal]( @s varchar(8000), @label varchar(1000) )
RETURNS varchar(1000)
AS
BEGIN
   DECLARE @value varchar(1000)
         , @value_start int
         , @value_end int
         
   SET @value_start = charindex(@label,@s)
   
   IF @value_start > 0
    BEGIN
      SET @value_start += len(@label) + 3
      SET @value_end = charindex(',',@s,@value_start)

      IF @value_end > @value_start
       BEGIN
         SET @value = substring(@s,@value_start,@value_end-@value_start)
       END
      ELSE
       BEGIN
         SET @value = substring(@s,@value_start,len(@s)-@value_start+1)
       END
    END

 RETURN ltrim(rtrim(@value))
END