UFN_ADDRESS_TRANSLATE

                create function dbo.UFN_ADDRESS_TRANSLATE(@ID as uniqueidentifier)
                returns nvarchar(300)
                as begin
                    return (
                        select
                            dbo.UFN_BUILDFULLADDRESS(ADDRESS.ID, ADDRESS.ADDRESSBLOCK, ADDRESS.CITY, ADDRESS.STATEID, ADDRESS.POSTCODE, ADDRESS.COUNTRYID)
                        from 
                            dbo.ADDRESS
                        where 
                            ADDRESS.ID = @ID
                    );
                end