UFN_TRANSLATIONFUNCTION_SALESORDERPREREGISTEREDREGISTRANTS

create function dbo.UFN_TRANSLATIONFUNCTION_SALESORDERPREREGISTEREDREGISTRANTS
(
    @ID uniqueidentifier
) 
returns nvarchar(850) 
as
begin
    declare @VALUE nvarchar(850) = '';

    select
        @VALUE = dbo.UFN_REGISTRANT_GETNAME(REGISTRANT.ID) + N' - ' + EVENT.NAME
    from
        dbo.REGISTRANT
    inner join
        dbo.EVENT on EVENT.ID = REGISTRANT.EVENTID
    where
        REGISTRANT.ID = @ID;

    return @VALUE;
end