Open topic with navigation

TIBCO ActiveSpaces® 4.8.0

# Operators

Operators are used in expressions to compare a column's value against another value.

Expressions can be composed with the operators from the following table:

Operator | Description
--- | ---
= == IS | Tests what is on each side of the operator for equality.
!= <> IS NOT | Tests what is on each side of the operator for inequality.
> |
< |
>= |
<= |
ISNULL IS NULL | Tests that the row does not contain a value in this column.
NOTNULL NOT NULL IS NOT NULL | Tests that the row contains a value in this column.
BETWEENvalue_1 and value_2 | Requires two values, separated by the keyword and. The range includes the end values.
IN(value [,value ]* ) | Requires a set of values, separated by commas, surrounded by parentheses.
value_1 LIKE value_2 | Searches the left operand for the pattern specified by the right operand. For details about the LIKE operator, see LIKE Operator.

## Value

value can be any value of the same data type as the column's data type.

Copyright © 2009-2022. Cloud Software Group, Inc. All Rights Reserved.