CREATE FUNCTION dbo.split ( @in NVARCHAR(4000) )

RETURNS @result TABLE

( seqNr INT IDENTITY(1, 1)

, item NVARCHAR(100)

)

AS BEGIN

DECLARE @i INT

SET @i = 1

WHILE ( CHARINDEX(',', @in) > 0 )

BEGIN

INSERT INTO @result ( item )

SELECT LTRIM(RTRIM(SUBSTRING(@in, 1, CHARINDEX(',', @in) - 1)))

SET @in = SUBSTRING(@in, CHARINDEX(',', @in) + 1, LEN(@in))

SET @i = @i + 1

END

INSERT INTO @result ( item )

SELECT LTRIM(RTRIM(@in))

RETURN

END

Regards,

Andras