DQ alternate for NOT EQUAL

Products

• Datacom
• DATACOM - AD
• Datacom/AD
• Datacom/DB

Issue/Introduction

What are the comparison operator available under Dataquery DQL?

Environment

Release: All supported releases.

Resolution

Operator                          Alternate Entry      Explanation
EQUAL                             EQ, =                Select exact value.
NOT EQUAL                         NE, ¬=               Select all data that is not the exact value.
GREATER THAN                      GT, >                Select data with higher value.
GREATER THAN OR EQUAL TO          GTE                  Select data of equal or higher value.
LESS THAN                         LT, <                Select data lower than value.
LESS THAN OR EQUAL TO             LTE                  Select data of equal or lower value.
CONTAINING                        none                 Select data that contains value (you do not need to know position of value within column data).
NOT                               ¬                    Select all data that is not related as specified (can use before any of the above operators except NOT EQUAL).

Additional Information

Using Dataquery