XOR (MDX)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Performs a logical exclusion on two numeric expressions.

Syntax


Expression1 XOR Expression2  

Parameters

Expression1
A valid Multidimensional Expressions (MDX) expression that returns a numeric value.

Expression2
A valid MDX expression that returns a numeric value.

Return Value

A Boolean value that returns true if one and only one argument evaluates to true; otherwise, false.

Remarks

The XOR operator treats both parameters as Boolean values (zero, 0, as false; otherwise, true) before the operator performs the logical exclusion. The following table illustrates how the XOR operator performs the logical exclusion.

Expression1 Expression2 Return Value
true true false
true false true
false true true
false false false

See Also

MDX Operator Reference (MDX)