==
|
This comparison operator compares
the expression on the left hand side to the one on the right and checks
if they are identical. Numerical expressions, strings, as well as
logical expressions can be compared.
2 |
== |
3 |
FALSE |
"LogiView" |
== |
"LogiView" |
TRUE |
"LogiView" |
== |
"DataView"
|
FALSE |
|
!=
|
This comparison operator compares
the expression on the left hand side to the one on the right and checks
if they differ. Numerical expressions, strings, as well as logical
expressions can be compared.
2 |
!= |
3 |
TRUE |
"LogiView" |
!= |
"LogiView" |
FALSE |
"LogiView" |
!= |
"DataView"
|
TRUE |
|
=%
|
This comparison operator compares the expression on the left hand side to the one on the right and checks if they are identical with the exception of the following special characters that have a wild card function:
% |
Arbitrary number of arbitrary characters. |
? |
One arbitrary character. |
(Depending on the database, different special characters ('%' and '_') may be used).
Only string expressions can be compared using wild card characters.
Example:
"DataView"
|
=% |
"????View" |
TRUE |
"LogiView" |
=% |
"Lo%Vi?w" |
TRUE |
"LogiView" |
=% |
"Logi%" |
TRUE |
"Logi%" |
=% |
"LogiView" |
FALSE |
|
 |
Please note that only the
right string expression may contain wild cards. |
<
|
This comparison operator compares the expressions and checks if the one on the left hand side is smaller than the one on the right. Only numerical expressions may be compared.
|
>
|
This comparison operator compares the expressions and checks if the one on the left hand side is greater than the one on the right. Only numerical expressions may be compared.
|
<=
|
This comparison operator compares the expressions and checks if the one on the left hand side is smaller or equal to the one on the right. Only numerical expressions may be compared.
|
>=
|
This comparison operator compares the expressions and checks if the one on the left hand side is greater or equal to the one on the right. Only numerical expressions may be compared.
|