thank you very much!

Thanks SSChampion.

I know about concat over XML.

I want to know the reason for this behavior stranngo.

Fast, but not good. (

DECLARE @inputString varchar(MAX) = '1<i>;2;4;5;'

Result of exec is 'XML parsing: line 1, character 97257, unexpected end of input'.

You need check input string.

Small Code for 2008 SQL. )

CREATE FUNCTION dbo.fn_Split

(

@InputString VARCHAR(MAX),

@Delimiter VARCHAR(MAX)

)

RETURNS @data TABLE (

Data VARCHAR(MAX)

)

AS

BEGIN

DECLARE @DelimitierLen BIGINT = LEN(@Delimiter)

DECLARE @DelimiterCharIndex BIGINT = CHARINDEX(@Delimiter,@InputString)

WHILE...