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

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

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

INSERT  INTO @SourceTable
VALUES  ( 1, '1;2' ),
        ( 2, '1;3;5' )


-- DECLARE expression to evaluate
DECLARE @sqlnet SQLNET = SQLNET::New('Split(s, ";").Select(x => Convert.ToInt32(x)).Where(x => x > 1)')

-- 1 | 2
-- 2 | 3
-- 2 | 5
SELECT  RowID ,
        Value_1
FROM    @SourceTable
        CROSS APPLY ( SELECT    Value_1
                      FROM      dbo.SQLNET_EvalTVF_1(@sqlnet.ValueString('s',
                                                              DelimitedString))
                    ) AS SplitTable
ORDER BY RowID