There are lots of split function for tsql, most of them is lots of lines of code !
Always on some cases we need to split concatted fields with a delimeter.
I think this this one is the best and the shortest split function for tsql based on xml functionality
CREATE FUNCTION [dbo].[SplitByXmlBase](@str varchar(max),@delimeter char)
RETURNS @table TABLE(Value varchar(4000))
Declare @x XML
Select @x = cast(''+ replace(@str,@delimeter,'')+ '' as xml)
select t.value('.', 'varchar(4000)') as Value from @x.nodes('/A') as x(t)