Inserting Comma Separated values sql server

declare @inputdata nvarchar(4000)declare @seperator nvarchar(5)

declare @seperatedData TABLE ( id int identity(1,1),  data nvarchar(4000))

set @inputdata = '1,9,3,4,6,8'

set @seperator = ','

WHILE (Charindex(@seperator,@inputdata)>0)

BEGIN

    INSERT INTO @seperatedData (data) values

    (ltrim(rtrim(Substring(@inputdata,1,Charindex(@seperator,@inputdata)-1))))

    SELECT  @inputdata = Substring(@inputdata,Charindex(@seperator,@inputdata)+1,len(@inputdata))  

END

INSERT INTO @seperatedData (data) values (ltrim(rtrim(@inputdata)))

SELECT * FROM @seperatedData

OutPut:
1
2
3
4
5