USP_DATALIST_LODGINGLOCATIONS

            CREATE procedure dbo.USP_DATALIST_LODGINGLOCATIONS
                (
                    @CITY nvarchar(50) = '',
                    @NAME nvarchar(100) = ''
                )
            as
            set nocount on;

            select 
        EVENTLODGINGLOCATION.ID,
                EVENTLODGINGLOCATION.NAME,
                EVENTLODGINGLOCATION.ADDRESSBLOCK,
                EVENTLODGINGLOCATION.CITY,
        STATE.ABBREVIATION as STATE,
                EVENTLODGINGLOCATION.POSTCODE,
        NF.NAME as CONTACT,
        EVENTLODGINGLOCATION.PHONENUMBER
            from 
        dbo.EVENTLODGINGLOCATION
            outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(EVENTLODGINGLOCATION.CONSTITUENTID) NF
        left join
        dbo.STATE on STATE.ID = EVENTLODGINGLOCATION.STATEID
            where
                (@CITY = '' or EVENTLODGINGLOCATION.CITY like @CITY + '%')
                and (@NAME = '' or EVENTLODGINGLOCATION.NAME like @NAME + '%')
            order by 
        EVENTLODGINGLOCATION.NAME;