Or Operator

Updated: March 2009

Performs a logical disjunction on two expressions.

result = expression1 Or expression2

result

Any numeric variable.

expression1

Any expression.

expression2

Any expression.

If either or both expressions evaluate to True, result is True. The logical operation is not short-circuited. All expressions are evaluated.

The following table illustrates how result is determined:

If expression1 is

And expression2 is

Then result is

True

True

True

True

False

True

True

Null

True

False

True

True

False

False

False

False

Null

Null

Null

True

True

Null

False

Null

Null

Null

Null

The Or operator also performs a bitwise comparison of identically positioned bits in two numeric expressions and sets the corresponding bit in result according to the following table:

If bit in expression1 is

And bit in expression2 is

Then result is

0

0

0

0

1

1

1

0

1

1

1

1

Date

History

Reason

March 2009

Added sentence to remarks.

Customer feedback.

Community Additions

Show: