UFN_OPPORTUNITYDESIGNATIONCANDIDATE_GETNAME

            create function dbo.UFN_OPPORTUNITYDESIGNATIONCANDIDATE_GETNAME
            (
                @ID uniqueidentifier
            )
            returns nvarchar(154)
            with execute as caller
            as
            begin
                declare @NAME nvarchar(154);
                select @NAME = dbo.UFN_CONSTITUENT_BUILDNAME(@ID);
                return coalesce(@NAME, '');
            end