Not

Table of Contents

Overview

Example

See also
Related

Overview
The NOT keyword performs a not operation on logical operators such as LIKE and BETWEEN, allowing a query to exclude data that does not fall within given ranges

Example

Selects records where the text does not begin with 'Cat'.

SELECT * FROM WordList:Word WHERE Text NOT LIKE 'Cat'

Selects records where the Id does not begin fall between a given range.

SELECT * FROM WordList:Word WHERE Id NOT BETWEEN 0 AND 600010