UFN_REGISTRANT_GETSEQUENCEID

                create function dbo.UFN_REGISTRANT_GETSEQUENCEID(@ID uniqueidentifier) returns nvarchar(50) 
                as
                begin
                    declare @SEQUENCEID nvarchar(50);
                    select @SEQUENCEID = convert(nvarchar(50), [SEQUENCEID]) from dbo.[REGISTRANT] where [ID] = @ID;
                    return @SEQUENCEID;
                end