operators-comparison.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	ms.custom
Comparison Operators (DMX)	Comparison Operators (DMX)	minewiskan	owend	owend	02/17/2022	sql	analysis-services	reference	dmx

Operators - Comparison

[!INCLUDEssas]

You can use comparison operators with scalar data in any Data Mining Extensions (DMX) expression in [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion]. Comparison operators evaluate to a Boolean data type; they return TRUE or FALSE based on the outcome of the tested condition.

The following table identifies the comparison operators that DMX supports.

Operator	Description
< (Less Than) (DMX)	For arguments that evaluate to a non-null value, returns TRUE if the value of the argument on the left is less than the value of the argument on the right; returns FALSE otherwise. If either argument or both arguments evaluate to a null value, the operator returns a null value.
> (Greater Than) (DMX)	For arguments that evaluate to a non-null value, returns TRUE if the value of the argument on the left is greater than the value of the argument on the right; returns FALSE otherwise. If either argument or both arguments evaluate to a null value, the operator returns a null value.
= (Equal To) (DMX)	For arguments that evaluate to a non-null value, returns TRUE if the value of the argument on the left is equal to the value of the argument on the right; returns FALSE otherwise. If either argument or both arguments evaluate to a null value, the operator returns a null value.
<> (Not Equal To) (DMX)	For arguments that evaluate to a non-null value, returns TRUE if the value of the argument on the left is not equal to the value of the argument on the right; returns FALSE otherwise. If either argument or both arguments evaluate to a null value, the operator returns a null value.
<= (Less Than or Equal To) (DMX)	For arguments that evaluate to a non-null value, returns TRUE if the value of the argument on the left is less than or equal to the value of the argument on the right; returns FALSE otherwise. If either argument or both arguments evaluate to a null value, the operator returns a null value.
>= (Greater Than or Equal To) (DMX)	For arguments that evaluate to a non-null value, returns TRUE if the value of the argument on the left is greater than or equal to the value of the argument on the right; returns FALSE otherwise. If either argument or both arguments evaluate to a null value, the operator returns a null value.

You can also use comparison operators in DMX statements and functions to look for a condition.

See Also

Data Mining Extensions (DMX) Reference
Data Mining Extensions (DMX) Function Reference
Data Mining Extensions (DMX) Operator Reference
Data Mining Extensions (DMX) Statement Reference
Data Mining Extensions (DMX) Syntax Conventions
Data Mining Extensions (DMX) Syntax Elements
Expressions (DMX)
General Prediction Functions (DMX)
Operators (DMX)
Structure and Usage of DMX Prediction Queries
Understanding the DMX Select Statement