DECLARE @TEST VARCHAR(30)
SET @TEST = '1,2,3,47, 89, 67'
DECLARE @Current INT


DECLARE @LISTINT TABLE (Number INT)

WHILE (LEN(@TEST) > 0)
BEGIN
    IF (Charindex(',', @TEST) > 0)
    BEGIN
        SET @Current = LEFT(@TEST, Charindex(',', @TEST) - 1)
        
        SET @TEST = RIGHT(@TEST, LEN(@TEST) - Charindex(',', @TEST))
        
    END
    ELSE
    BEGIN
        SET @Current = CAST(@TEST AS INT)
        SET @TEST = NULL
    END

    INSERT INTO @LISTINT VALUES(@Current)
    SET @Current = NULL
END

SELECT Number
FROM @LISTINT