Operator |
SQL Equivalent |
---|---|
= |
= (equal) |
IS EMPTY |
IS NULL |
NOT EMPTY |
IS NOT NULL |
CONTAINS |
LIKE '%value%" |
BEGINS |
LIKE 'value%' |
ENDS |
LIKE ;%value' |
IN |
For numbers: IN (1,2,3) or for text: IN ('a', 'b', 'c') |
!= |
!= (not equal) |
%lt; |
< (less than) |
> |
> (greater than) |
>= or => |
>= (greater or equal) |
=< or <= |
<= (less than or equal) |