>CREATE FUNCTION [dbo].[Split]( > @List VARCHAR(8000), > @Del VARCHAR(1) >) RETURNS TABLE >AS >RETURN ( > WITH Tokens AS ( > SELECT > StartPos = 1, > EndPos = CHARINDEX(@Del, @List COLLATE Latin1_General_BIN2 +@del) > UNION ALL > SELECT > EndPos + 1, > CHARINDEX(@Del, @List COLLATE Latin1_General_BIN2 + @del, EndPos + 1) > FROM Tokens > WHERE EndPos > 0 > ) > SELECT > SUBSTRING(@List, StartPos, EndPos - StartPos) as value > FROM Tokens > WHERE EndPos <> 0 >) >>