데이타베이스/MSSQL
MSSQL SPLIT
유키공
2021. 7. 19. 17:54
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
END