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


#   Display the MySQL version
SELECT version();


#  Switch to the correct database
USE uls


#  Delete "unwanted" records
DELETE FROM PUBACC_LO
#  WHERE NOT (location_state='CA')
  WHERE NOT (location_state='CA' OR location_state='')
;