UFN_PLEDGEREMINDERPROCESS_GETNAME

                create function dbo.UFN_PLEDGEREMINDERPROCESS_GETNAME(
                    @ID uniqueidentifier
                ) 
                returns nvarchar(100) with execute as caller
                as
                begin
                    declare @NAME nvarchar(100)
                    select @NAME = NAME from dbo.PLEDGEREMINDERPROCESS where ID = @ID
                    return @NAME
                end