OR operator

OR operator

Returns a TRUE value if either of two logical expressions is TRUE.

Syntax
expression OR expression 
expression

A logical expression (a constant, field name, variable name or expression whose value is logical, that is, TRUE/FALSE, YES/NO).

Example

This procedure lists Customers who have no postal code (PostalCode = "") or that have no telephone number (Phone = ""), and displays how many Customers are in the list:
r-or.p
FOR EACH Customer NO-LOCK  
  WHERE Customer.PostalCode = "" OR Customer.Phone = "": 
  DISPLAY Customer.CustNum Customer.Name (COUNT) Customer.City Customer.State 
    Customer.PostalCode Customer.Phone. 
END. 
See also

AND operator, NOT operator

`expression` OR `expression`

r-or.p
FOR EACH Customer NO-LOCK WHERE Customer.PostalCode = "" OR Customer.Phone = "": DISPLAY Customer.CustNum Customer.Name (COUNT) Customer.City Customer.State Customer.PostalCode Customer.Phone. END.

OpenEdge Release 10.2B