#   qryDeleteFreqsAbove1GHz.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_FR
  WHERE convert( PUBACC_FR.frequency_assigned, DECIMAL ) >= 1000
;