UFN_PLANNEDGIFTLETTERCODE_GETNAME

            CREATE function dbo.UFN_PLANNEDGIFTLETTERCODE_GETNAME
            (
                @ID uniqueidentifier
            )
            returns nvarchar(100)
            with execute as caller
            as
            begin
                declare @NAME nvarchar(100);
                select @NAME = NAME from dbo.PLANNEDGIFTLETTERCODE where ID = @ID;
                return coalesce(@NAME, '');
            end