Progress
SQL-92
Guide and Reference


Logical Operators: OR, AND, NOT

Logical operators combine multiple search conditions. SQL evaluates multiple search conditions in the following order:

EXAMPLE

The following example illustrates the use of logical operators:

SELECT * FROM customer
     WHERE name = ’NYQUIST’ OR name = ’SMITH’ ;
 
SELECT * FROM customer
     WHERE city = ’PRINCETON’ AND state = ’NJ’ ;
 
SELECT * FROM customer
     WHERE NOT (name = ’NYQUIST’ OR name = ’SMITH’) ; 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095