Be aware of the possibility of markup characters within your data.

Eg, the following split will fail:

Declare @xml as xml,@str as varchar(100),@delimiter as varchar(10)

SET @STR='A4,C,D,E'

SET @delimiter =','

SET @xml = cast((''+replace(@str,@delimiter ,'')+'') as xml)