Specifications

>= Greater than or equal to
= Equal to
<> Not equal to
BETWEEN Determines whether the value of an expression falls within a specified range of
values
LIKE Compares a string expression to a pattern ; you can specify the complete value (for
example, Like "F6DEX"), or use wildcard characters to find a range of values (for
example, Like "F6*")
Syntax
The conventions are the followings :

SQL statements are not case sensitive

string expressions are enclosed in quotes : 'alpha'

decimal separator is the dot : 14.195

date use US convention enclosed in # : #mm/dd/yyyy#

logical values are True or False
Examples
SELECT * FROM LOGBOOK WHERE QSL_RCVD = 'Y' ORDER BY DATE_ON : this query selects all
records from the logbook table for which QSL received is YES; records are sorted by
ascending date.
SELECT DISTINCT IOTA FROM LOGBOOK WHERE QSL_RCVD = 'Y' : this query selects the
distinct values for the IOTA field for which QSL received is Yes.
SELECT * FROM Logbook WHERE CALL LIKE '*FR*' AND DATE_ON > = #04/25/2000# : this
query selects all the QSOs made after the April, 25 2000 for which the call field contains FR.
SELECT * FROM LOGBOOK WHERE BAND = '2m' and (MODE='FM' OR MODE="AM" OR
MODE="SSB" OR MODE= 'USB' OR MODE='LSB' ) AND COMMENT NOT LIKE '*RPT*' AND
COMMENT NOT LIKE '*REPEATER*' AND QSL_RCVD='Y' ORDER BY DXCC : this query selects all
the confirmed QSOs made on 2 meters in phone (AM or FM or SSB or USB or LSB) ; QSO with
"RPT" or "REPEATER" in the comment field are excluded. The records are sorted by DXCC.
Some other useful queries are listed in the Advanced search topic (Logbook).
Page 374