Logical Operators (Visual Database Tools)

  • Article

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'

See Also

Other Resources

Designing Queries and Views

Reference (Visual Database Tools)