Operators

Supported

The following are the SQL operators that can be used:

Table 174. 

=

<

>

<=

>=

<>

between

exists

in

like

not between

not exists

not in

not like

is

is not

=all

!=all

<all

>all

<=all

>=all

=any

!=any

<any

>any

<=any

>=any

!=any

|

~

 

Note: Concatenation operator (+) for String datatype is supported.

Unsupported

"^" is unsupported.