출처1 :<a href="http://blog.aliencube.org/ko/2014/02/10/converting-array-like-table-from-string-in-ms-sql/" target="_blank" class="tx-link">&nbsp;http://blog.aliencube.org/ko/2014/02/10/converting-array-like-table-from-string-in-ms-sql/</a>출처2 :&nbsp;<a href="http://stackoverflow.com/questions/2647/how-do-i-split-a-string-so-i-can-access-item-x" target="_blank" class="tx-link">http://stackoverflow.com/questions/2647/how-do-i-split-a-string-so-i-can-access-item-x</a>출처3 :&nbsp;<a href="http://www.codeproject.com/Articles/7938/SQL-User-Defined-Function-to-Parse-a-Delimited-Str" target="_blank" class="tx-link">http://www.codeproject.com/Articles/7938/SQL-User-Defined-Function-to-Parse-a-Delimited-Str</a> DECLARE @items NVARCHAR(MAX)SET @items = '111,222,333,444,555,666,777,888,999'&nbsp;DECLARE @delimiter NVARCHAR(1)SET @delimiter = ','&nbsp;DECLARE @item NVARCHAR(MAX)SET @item = NULL&nbsp;DECLARE @results TABLE (&nbsp;&nbsp;&nbsp; Item&nbsp;&nbsp;&nbsp;
NVARCHAR(MAX))&nbsp;WHILE LEN(@items) &gt; 0BEGIN&nbsp;&nbsp;&nbsp; DECLARE
@index&nbsp;&nbsp;&nbsp; INT&nbsp;&nbsp;&nbsp; SET @index = PATINDEX('%' + @delimiter + '%', @items)&nbsp;&nbsp;&nbsp; IF @index &gt; 0&nbsp;&nbsp;&nbsp; BEGIN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SET
@item = SUBSTRING(@items, 0, @index)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SET
@items = SUBSTRING(@items, LEN(@item + @delimiter) + 1, LEN(@items))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INSERT INTO @results ( Item ) VALUES ( @item )&nbsp;&nbsp;&nbsp; END&nbsp;&nbsp;&nbsp; ELSE&nbsp;&nbsp;&nbsp; BEGIN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SET
@item = @items&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SET
@items = NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INSERT INTO @results ( Item ) VALUES ( @item )&nbsp;&nbsp;&nbsp; ENDEND&nbsp;SELECT * FROM @results



































































&nbsp;

쿼리로 문자열 분리하기 Query for Split