dbo.BeSplit TSQL function to split by beginning and end string

       
ALTER FUNCTION dbo.BeSplit (
@re varchar(max),
@beg varchar(max),
@end varchar(max))
RETURNS varchar(max)
WITH EXECUTE AS CALLER
AS
BEGIN
declare @in  int = Charindex(@beg,@re)
declare @ou  int =-1
declare @locid varchar(max)
declare @l11 int =LEN(@beg)
if @in > 0
    set @ou = Charindex(@end,@re,@in)
    else
    return null

if @ou > 0
    set @locid= SUBSTRING ( @re ,@in+@l11 , @ou-(@in+@l11) )
    else
    set @locid= SUBSTRING ( @re ,@in+@l11 , LEN(@re)-(@in+@l11)+1)

  RETURN @locid
END;
GO

call example: select Page,dbo.BeSplit(Page,'locationid=','&') as locationid,dbo.BeSplit(Page,'comp=','&') as familyname from ga