Split function using XML in SQL SERVER

CREATE FUNCTION [dbo].[Split] (



 @String [nvarchar](max)

 ,@Delimiter [char](1)
)


RETURNS @temptable
TABLE ([items] [nvarchar](max))

AS

BEGIN

 DECLARE @xml  XML



SET @xml = cast(('<Node>' 

+ replace(@String, @Delimiter, '</Node><Node>')

+ '</Node>') AS XML)




INSERT INTO @temptable

SELECT N.value('.', 'nvarchar(max)') AS items 

FROM @xml.nodes('Node') AS T(N) 
RETURN

END