UFN_LETTERTEMPLATE_GETNAME

            create function dbo.UFN_LETTERTEMPLATE_GETNAME
            (
                @ID uniqueidentifier
            )
            returns nvarchar(100) with execute as caller
            as
            begin
                if @ID is null
                    return '';

                declare @NAME nvarchar(100);

                select @NAME = NAME
                from dbo.LETTERTEMPLATE
                where ID = @ID;

                return @NAME;
            end