UFN_EVENTLOCATION_GETINFORMATION

            CREATE function dbo.UFN_EVENTLOCATION_GETINFORMATION(@ID uniqueidentifier) returns nvarchar(400) with execute as caller
            as
            begin
                declare @INFORMATION nvarchar(400)
                declare @ADDRESS nvarchar(300)
                select 
                    @INFORMATION = NAME,
                    @ADDRESS = dbo.UFN_BUILDFULLADDRESS(EVENTLOCATION.ID, EVENTLOCATION.ADDRESSBLOCK, EVENTLOCATION.CITY, EVENTLOCATION.STATEID, EVENTLOCATION.POSTCODE, EVENTLOCATION.COUNTRYID)
                from 
                    dbo.EVENTLOCATION 
                where 
                    ID = @ID

                if len(@ADDRESS) > 0
                    set @INFORMATION = @INFORMATION + nchar(13) + nchar(10) + @ADDRESS;

                return @INFORMATION;
            end