[MS-SQL] 단위 문자열 row로 만들기

create FUNCTION Split
(
    @List nvarchar(2000),
    @SplitOn nvarchar(5)
) 
RETURNS @RtnValue table
(
    Value nvarchar(50)
)
AS 
BEGIN
    While (Charindex(@SplitOn,@List)>0)
    Begin
        Insert Into @RtnValue (value)
        Select Value = ltrim(rtrim(Substring(@List,1,Charindex(@SplitOn,@List)-1)))
        Set @List = Substring(@List,Charindex(@SplitOn,@List)+len(@SplitOn),len(@List))
    End

    Insert Into @RtnValue (Value)
    Select Value = ltrim(rtrim(@List))
Return
END

실행 : select * from dbo.Split('가, 나, 다', ',') - 쉼표단위로 잘라준다

결과화면