fnMakeVarCharTableFromString

        create function [dbo].[fnMakeVarCharTableFromString](@CharString nvarchar(2000), @Delim nvarchar(8))
        returns @CharTable TABLE([value] nvarchar(256))
        as
        BEGIN
            DECLARE @intPos INTEGER
            SET @intPos = CHARINDEX(@Delim,@CharString)
            WHILE @intPos > 0
                BEGIN
                INSERT INTO @CharTable SELECT LEFT(@CharString,@intPos-1)
                SET @CharString = SUBSTRING(@CharString,@intPos+1,LEN(@CharString)-@intPos)
                SET @intPos = CHARINDEX(@Delim,@CharString)
                END

            IF (LEN(@CharString) > 0)
                INSERT INTO @CharTable SELECT @CharString
            RETURN
        END