**THIS TOPIC APPLIES TO:**SQL Server (starting with 2008)Azure SQL DatabaseAzure SQL Data Warehouse Parallel Data Warehouse

In Multidimensional Expressions (MDX), set operators perform operations on members or sets, and return a set. You often use set operators as an alternate to several set functions in MDX expressions.

MDX supports the set operators listed in the following table.

Operator | Description |
---|---|

- (Except) | Returns the difference between two sets, removing duplicate members. This operator is functionally equivalent to the Except function. |

* (Crossjoin) | Returns the cross product of two sets. This operator is functionally equivalent to the Crossjoin function. |

: (Range) | Returns a naturally ordered set, with the two specified members as endpoints and all members between the two specified members included as members of the set. |

+ (Union) | Returns a union of two sets, excluding duplicate members. This operator is functionally equivalent to the Union (MDX) function. |

## See Also

MDX Function Reference (MDX)

MDX Operator Reference (MDX)

Operators (MDX Syntax)