select distinct cho_city, cho_state from tbl_cho_operators with (nolock) where ( ( cho_city like ) and 1 = 1 ) order by cho_city, cho_state #_data#