StringSplit function -SQL

This is a function used to split string and fie sql queries

ALTER PROCEDURE [Door].[XXXXXXXXXXXXXXXXXXXXXXXXXXx]

@GroupIdList varchar(max)

,@Type int

AS

BEGIN

DECLARE @Delimeter CHAR(1);