SQL/MX Quick Start (G06.24+, H06.03+)

Stating Conditions for Selecting Data
HP NonStop SQL/MX Quick Start—523724-002
3-5
Specifying What Not to Select
Rows with part numbers between 3000 and 5999 and the row with part number
2001 are not selected. In this example, AND is part of the BETWEEN predicate. It
does not connect two search conditions.
•
You can specify NOT BETWEEN, NOT IN, and NOT LIKE, but you cannot specify
NOT with a comparison operator. For example, you must use <> to indicate not
equal.