아미(아름다운미소)

DECLARE @valueList varchar(8000) DECLARE @pos INT DECLARE @len INT DECLARE @value varchar(8000) SET @valueList = '20030,20031,20033,20034,20065,20045,20044,' SET @pos = 0 SET @len = 0 WHILE CHARINDEX(',', @valueList, @pos+1)>0 BEGIN SET @len = CHARINDEX(',', @valueList, @pos+1) - @pos SET @value = SUBSTRING(@valueList, @pos, @len) SELECT @value SET @pos = CHARINDEX(',', @valueList, @pos+@len) +1..