Delimited column values into rows

Select * from 

  (Select Row_number() Over (Order by (select null)) r_num,

  CONVERT( XML, '' + REPLACE( 'a,b,c,d,e,f,g,h,i,j,k', ',', '' ) + '' ) AS XML_ROW) A

  

  CROSS APPLY 

        ( 

                SELECT DATA.ROW.value('.', 'VARCHAR(1000)') AS IND_ROW FROM A.XML_ROW.nodes('ROW') AS DATA(ROW)

        ) B