http://www.zzzprojects.com/sql-server-split-function-example/

sql-server-string-split-function-example-linq-projection-operators.sql

-- CREATE test table
DECLARE @SourceTable TABLE
    (
      RowID INT ,
      DelimitedString VARCHAR(8000)
    )

INSERT  INTO @SourceTable
VALUES  ( 1, 'a;b' ),
        ( 2, 'a;b;c' )


-- DECLARE expression to evaluate
DECLARE @sqlnet SQLNET = SQLNET::New('Split(s, ";").Select((x, i) => new {i, x })')


-- 1 | 0 | a
-- 1 | 1 | b
-- 2 | 0 | a
-- 2 | 1 | b
-- 2 | 2 | c
SELECT  RowID ,
        Value_1 ,
        Value_2
FROM    @SourceTable
        CROSS APPLY ( SELECT    Value_1 ,
                                Value_2
                      FROM      dbo.SQLNET_EvalTVF_2(@sqlnet.ValueString('s',
                                                              DelimitedString))
                    ) AS SplitTable
ORDER BY RowID, Value_1