select opr.cho_name, opr.cho_address, opr.cho_city, opr.cho_state, opr.cho_zipcode, opr.cho_phone, opr.cho_type from tbl_CHO_Operators opr with (nolock) where cho_id =