Query Parameter Operators

Specific operators can be used in the WHERE clause.

Note that the attribute and value operands must both be of the same data type.

Unless otherwise noted, each operator can be applied to all data types (Text, Numeric, Boolean and DateTime).

Operator Description Examples
= Equals - compares two values for equality.

Wildcards can be used when comparing attributes of type string. See Using Wildcards .

 INSTANCE.NAME = ‘LoanApproval’

INSTANCE.PRIORITY = 3

IsLoanApproved = TRUE

INSTANCE.COMPLETION_DATE = TS '2008-06-20T10:30:20'

<> Not equal to INSTANCE.PRIORITY <> 3
> Greater than INSTANCE. PRIORITY > 5000

Balance > 300.53

< Less than INSTANCE. PRIORITY < 5000
>= Greater than or equal to INSTANCE. PRIORITY >= 5000
<= Less than or equal to INSTANCE. PRIORITY <= 5000
LIKE Pattern match comparison - matches a string value against a pattern string containing wild-card characters. See Using Wildcards .

Applies to Text data types only.

 To match any processes with a module name that begins with “module”:

   MODULE.NAME LIKE ‘module%’

To match any processes with a module name that begins with “module number” and ends with a single character):

   MODULE.NAME LIKE ‘module number _’
BETWEEN Range comparison - tests whether a value is between two other values INSTANCE.PRIORITY BETWEEN 4000 AND 5000

INSTANCE.START_DATE between TS '2008-06-20T10:30:20' AND TS '2008-06-20T10:52:20';

IN Implements comparison to a list of values, that is, it tests whether a value matches any value in a list of values.

Applies to Text and Numeric data types only.

 MODULE.NAME IN ('moduleBalance’, 'modulePayment');
IS [NOT] NULL Tests whether the attribute has a value MODULE.NAME IS NOT NULL

Payment IS NULL

NOT Inverts the result of a condition clause MODULE.NAME NOT IN ('moduleBalance’, 'modulePayment');

INSTANCE.PRIORITY NOT BETWEEN 4000 AND 5000