Print Comma Seperated Values In SQL Server

DECLARE @Test VARCHAR(1000), @RecSet VARCHAR(500)
DECLARE @StartingPos INT,@RecPos INT
SET @StartingPos= 1
SET @Test = '1,2,3,'
WHILE @StartingPos<=LEN(@Test)
BEGIN
    SELECT @RecPos = CHARINDEX(',',@Test,@StartingPos)
    SELECT @RecSet=SUBSTRING(@Test,@StartingPos,@RecPos-@StartingPos)
    PRINT @RecSet
    SELECT @StartingPos=@RecPos+1
END