INSTALL function (code below) and use it to split a value

CREATE FUNCTION [dbo].[StringToTable]

(@RawString nvarchar(4000), @Delimiter nvarchar(10) )

RETURNS

@VList TABLE (RowID int IDENTITY(1,1),SplitedValue varchar(200))

AS

BEGIN

WITH CSVCte (StartPos, EndPos) AS

(SELECT 1 AS StartPos, CHARINDEX(@Delimiter , @RawString + @Delimiter) AS EndPos

UNION ALL

SELECT EndPos + 1 AS StartPos , CHARINDEX(@Delimiter,@RawString + @Delimiter , EndPos + 1) AS EndPos

FROM CSVCTE WHERE CHARINDEX(@Delimiter, @RawString + @Delimiter, EndPos + 1) <> 0)

INSERT INTO @VList

SELECT SUBSTRING(@RawString, StartPos,EndPos - StartPos) FROM CSVCte

RETURN

END

GO

-- sample call: select SplitedValue from dbo.StringToTable('A,B,C,D,E,F,G', ',')