#   qryDeleteControlNotStateCA.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_CP
#  WHERE NOT (state_code='CA' OR state_code='')
  WHERE NOT (state_code='CA')
;