fnMakeGuidsTableFromString

            CREATE FUNCTION [dbo].[fnMakeGuidsTableFromString](@GuidString nvarchar(4000), @Delim nvarchar(8))
            RETURNS @GuidTable TABLE(g uniqueidentifier)
            AS
            BEGIN
                DECLARE @intPos INTEGER
                SET @intPos = CHARINDEX(@Delim,@GuidString)
                WHILE @intPos > 0
                    BEGIN
                    INSERT INTO @GuidTable SELECT LEFT(@GuidString,@intPos-1)
                    SET @GuidString = SUBSTRING(@GuidString,@intPos+1,LEN(@GuidString)-@intPos)
                    SET @intPos = CHARINDEX(@Delim,@GuidString)
                    END

                IF (LEN(@GuidString) > 0)
                    INSERT INTO @GuidTable SELECT @GuidString
                RETURN
            END