Logical Operators

Visual Database Tools

previous page next page
Visual Database Tools

Logical Operators

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

Reference

previous page start next page