UFN_TRANSLATIONFUNCTION_VENDOR

        CREATE function dbo.UFN_TRANSLATIONFUNCTION_VENDOR
        (
            @ID uniqueidentifier
        )
        returns nvarchar(154)
        as
        begin
            declare @s nvarchar(154);
            if @ID is null return '';
            select @s = NAME from dbo.CONSTITUENT where ID = @ID;
            return @s;
        end