declare @input varchar(50)='100,200,300,400,500'

select '1', q2.value from

( SELECT cast('<x>'+replace(@input,',','</x><x>')+'</x>' as xml) as txml ) q1 CROSS APPLY

( SELECT x.value('.','varchar(100)') as value FROM txml.nodes('x') as f(x) )q2