Data Director User Guide

Back Next

Comparison Operators

Use comparison operators when you want to restrict the search results based on the values for the attribute you search on.

The following table describes the operators that you can use and provides an example for each operator:

Operator	Description	Example
=	equals	MATCH_PATH_COMPONENT.C_MT_CUSTOMER\|ACCOUNT_CD = '123456879'
>	greater than	MATCH_PATH_COMPONENT.C_MT_ADDRESS\|POSTAL_CD > 42000
<	less than	MATCH_PATH_COMPONENT.C_MT_ADDRESS\|POSTAL_CD < 30000
>=	greater than or equals	MATCH_PATH_COMPONENT.C_MT_CUSTOMER\|SALES >= 1000000
<=	less than or equals	MATCH_PATH_COMPONENT.C_MT_CUSTOMER\|SALES <= 1000000
BETWEEN	between two values (inclusive)	MATCH_PATH_COMPONENT.C_MT_ADDRESS\|POSTAL_CD BETWEEN 94000 AND 96000