Logical Operators

See Also Tasks

You can combine or modify search conditions using the standard logical operators listed in the following table. The operators are listed in the order that they are evaluated.

Operator	Meaning	Example
NOT	Logical opposite of condition	`SELECT * FROM employee` `WHERE NOT (fname = 'Ann')`
AND	Both conditions must apply	`SELECT * FROM employee WHERE lname = 'Smith' AND fname = 'Ann'`
OR	Either condition can apply	`SELECT * FROM employee WHERE region = 'UK' OR region = 'FRA'`