#   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_FR
# (*incorrect* syntax)
#  WHERE ( convert( frequency_assigned, DECIMAL ) >= 825 AND convert( frequency_assigned, DECIMAL ) <= 849 )
#        OR
#        ( convert( frequency_assigned, DECIMAL ) >= 869 AND convert( frequency_assigned, DECIMAL ) <= 894 )

# (*correct* syntax)
  WHERE ( frequency_assigned + 0 >= 825 AND frequency_assigned + 0 <= 849 )
        OR
        ( frequency_assigned + 0 >= 869 AND frequency_assigned + 0 <= 894 )
;