UFN_TRIBUTE_GETNAME

create function dbo.UFN_TRIBUTE_GETNAME(@ID uniqueidentifier) 
returns nvarchar(510) 
with execute as caller
as
                begin
                    declare @NAME nvarchar(255);

                    select 
                        @NAME = TRIBUTE.TRIBUTETEXT 
                    from 
                        dbo.TRIBUTE
                    where 
                        TRIBUTE.ID = @ID;

                    return coalesce(@NAME, '');
                end