select vend_id,vend_name vname,vend_address vaddress,vend_city vcity from Vendors order by vend_name asc