[MS-SQL] 배열이용

DECLARE @TUserID VARCHAR(16)
DECLARE @TUserList VARCHAR(8000)
SET @TUserList = '이순신,김유신,강감찬,을지문덕,광개토대왕'

WHILE CHARINDEX(',', @TUserList) <> 0 OR LEN(RTRIM(@TUserList)) > 0
BEGIN
     IF (CHARINDEX(',', @TUserList) = 0)
     BEGIN
          SET @TUserID = @TUserList
          SET @TUserList = ''
     END
     ELSE
     BEGIN
          SELECT @TUserID = SUBSTRING(@TUserList, 0, CHARINDEX(',', @TUserList))
          SET @TUserList  = SUBSTRING(@TUserList, CHARINDEX(',', @TUserList) + 1, LEN(@TUserList))
     END

     PRINT(@TUserID)
END