Open topic with navigation

TIBCO ActiveSpaces® - Enterprise Edition 5.0.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.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO ActiveSpaces® - Enterprise Edition

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