Split no Transact-SQL

declare @s varchar(100)
set @s='aaaa,bbbb,cccc'
declare @xml xml
set @xml = cast('<tag>' + replace(@s, ',','</tag><tag>') + '</tag>' as xml)
select T.i.value('.', 'varchar(255)') from @xml.nodes('tag') T(i)