by iatanasov
29. January 2008 18:51
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