CONDOP_BETWEEN
and CONDOP_NOTBETWEEN
include the
bounds of the specified interval.
Additional Information
Name |
Value |
Description |
CONDOP_LIKE |
1 |
LIKE
The property value must be like the specified value. You can use the wildcards *, ?, % and _ with this operator.
|
CONDOP_NOTLIKE |
2 |
NOT LIKE
The property value must not be like the specified value.
|
CONDOP_IN |
3 |
IN
The property value must be in the specified values.
|
CONDOP_NOTIN |
4 |
NOT IN
The property value must not be in the specified values.
|
CONDOP_ISNULL |
5 |
IS NULL
The property value must be NULL.
|
CONDOP_ISNOTNULL |
6 |
IS NOT NULL
The property value must not be NULL.
|
CONDOP_LS |
7 |
<
The property value must be smaller than the specified value.
|
CONDOP_LE |
8 |
<=
The property value must be smaller than or equal the specified value.
|
CONDOP_GR |
9 |
>
The property value must be greater than the specified value.
|
CONDOP_GE |
10 |
>=
The property value must be greater than or equal the specified value.
|
CONDOP_EQ |
11 |
=
The property value must equal the specified value.
|
CONDOP_NE |
12 |
<>
The property value must not equal the specified value.
|
CONDOP_BETWEEN |
13 |
BETWEEN
The property value must be in the specified interval. The bounds are included.
|
CONDOP_NOTBETWEEN |
14 |
NOT BETWEEN
The property value must not be in the specified interval. The bounds are included.
|
CONDOP_SOUNDSLIKE |
15 |
SOUNDS LIKE |
CONDOP_SOUNDSNOTLIKE |
16 |
SOUNDS NOT LIKE |
CONDOP_CONTAINS |
17 |
CONTAINS |
CONDOP_NOTCONTAINS |
18 |
NOT CONTAINS |
CONDOP_INCLUDES |
19 |
INCLUDES |
CONDOP_NOTINCLUDES |
20 |
NOT INCLUDES |