#   qryDeleteCellular.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_EN
#  WHERE entity_name LIKE '%NEXTEL%'
#;

#  Delete "unwanted" records (this query is better than the one above)
DELETE FROM PUBACC_FR
  WHERE ( convert( frequency_assigned, DECIMAL ) >= 825 AND convert( frequency_assigned, DECIMAL ) <= 849 )
        OR
        ( convert( frequency_assigned, DECIMAL ) >= 869 AND convert( frequency_assigned, DECIMAL ) <= 894 )
;