USP_SIMPLEDATALIST_DELIVERYADDRESS

                CREATE procedure USP_SIMPLEDATALIST_DELIVERYADDRESS(
                    @CONSTITUENTID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        ADDRESS.ID VALUE,
                            coalesce('('+ADDRESSTYPECODE.DESCRIPTION+') ','') +  
                            dbo.UFN_BUILDFULLADDRESS(ADDRESS.ID, ADDRESS.ADDRESSBLOCK,ADDRESS.CITY,ADDRESS.STATEID,ADDRESS.POSTCODE,ADDRESS.COUNTRYID) LABEL
                    from ADDRESS 
                        left join ADDRESSTYPECODE on ADDRESSTYPECODE.ID = ADDRESS.ADDRESSTYPECODEID
                    where ADDRESS.CONSTITUENTID = @CONSTITUENTID and 
                        ADDRESS.ADDRESSBLOCK <> ''
                    order by ADDRESS.SEQUENCE