Share via


OR (DMX)

A logical operator that performs a logical disjunction on two numeric expressions.

Syntax

Expression1 OR Expression2

Parameters

  • Expression1
    A valid Data Mining Extensions (DMX) expression that returns a numeric value.
  • Expression2
    A valid DMX expression that returns a numeric value.

Return Value

A Boolean value that returns TRUE if either argument or both arguments evaluate to TRUE; otherwise FALSE.

Remarks

Both arguments are treated as Boolean values (0 as FALSE; otherwise TRUE) before the operator performs the logical disjunction. If either argument or both arguments evaluate to TRUE, the operator returns TRUE. If Expression1 evaluates to TRUE and Expression2 evaluates to FALSE, the operator returns TRUE.

The following table illustrates how the logical disjunction is performed.

If Expression1 is If Expression2 is Return value is

TRUE

TRUE

TRUE

TRUE

FALSE

TRUE

FALSE

TRUE

TRUE

FALSE

FALSE

FALSE

See Also

Reference

Data Mining Extensions (DMX) Operator Reference
Logical Operators (DMX)
Operators (DMX)

Help and Information

Getting SQL Server 2005 Assistance