select default_name, iso from countries order by default_name select 1 from us_states where abbrev = upper(:region) or state_name = upper(:region)