1. CHARINDEX() 함수와 SUBSTRING함수를 이용한 분리 (2016버전 이전) DECLARE @data VARCHAR(MAX) DECLARE @separator CHAR SET @data = 'a,bb,ccc,dddd,eeeee,ffffff,ggggggg,hhhhhhhh,iiiiiiiii'; SET @separator = ',' DECLARE @substring VARCHAR(MAX) DECLARE @dividepos INT SET @dividepos = CHARINDEX(@separator, @data) WHILE @dividepos 0 OR LEN(@data) > 0 BEGIN SET @dividepos = CHARINDEX(@separator, @data) IF @dividepos = ..
