OR operator (logical)

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 (logical), NOT operator (logical)