UFN_GET_EVENTAPPEAL_BY_MAPID

        CREATE function dbo.UFN_GET_EVENTAPPEAL_BY_MAPID(@APPEALMAPID int)
        returns nvarchar(400)
        with execute as caller
        as begin
            return (select top 1
                        APPEAL.NAME as APPEALNAME
                    from
                        dbo.BBNCAPPEALIDMAP
                        inner join dbo.APPEAL on Appeal.ID =BBNCAPPEALIDMAP.APPEALID
                    where Appeal.ISACTIVE =1 and 
                        BBNCAPPEALIDMAP.ID = @APPEALMAPID)
        end