You can use below script to split the string with comma

DECLARE @s-2 varchar(max),

@Split char(1),

@X xml

SELECT @s-2 = 'A,B,C',

@Split = ','

SELECT @X = CONVERT(xml,'<root><splittedvalues>'...