#   qryFixLowerCase.sql
#   SQL
#   n6lhv@arrl.net (Wayne Smith)


#   Display the MySQL version
SELECT version();


#  Switch to the correct database
USE uls


#  Change Lower Case to Upper Case
UPDATE pubacc_lo
  SET location_address = UPPER( location_address ),
      location_city = UPPER( location_city ),
      location_county = UPPER( location_county ),
      location_state = UPPER( location_state )
;

#  Change Lower Case to Upper Case
UPDATE pubacc_en
  SET entity_name = UPPER( entity_name )
;

#  Change Lower Case to Upper Case
UPDATE pubacc_cp
  SET control_address = UPPER( control_address ),
      control_city = UPPER( control_city ),
      control_county = UPPER( control_county ),
      state_code = UPPER( state_code )
;