UFN_CONSTITUENT_GETNAMEONMEMBERSHIPCARD

            create function dbo.UFN_CONSTITUENT_GETNAMEONMEMBERSHIPCARD
            (
                @MEMBERSHIPPROGRAMID uniqueidentifier,
                @CONSTITUENTID uniqueidentifier
            )
            returns nvarchar(700)
            with execute as caller
            as begin

                declare @NAME nvarchar(700) = ''

                -- Find name format

                declare @FORMATID uniqueidentifier
                select
                    @FORMATID = NFP.ADDRESSEEFUNCTIONID
                from
                    dbo.MEMBERSHIPPROGRAM MP
                    inner join dbo.NAMEFORMATPARAMETER NFP on NFP.ID = MP.NAMEFORMATID
                where
                    MP.ID = @MEMBERSHIPPROGRAMID

                if @FORMATID is null
                begin
                    -- Use system default

                    select @NAME = NAME from dbo.UFN_CONSTITUENT_DISPLAYNAME(@CONSTITUENTID)
                end
                else
                begin
                    -- Use specified format

                    set @NAME = dbo.UFN_NAMEFORMAT_FROMID_INTERNAL(@FORMATID, @CONSTITUENTID, 0)
                end

                return @NAME
            end