Feedback
3.3
Comparison OperatorsΒΆ
These operations test whether two expressions are equal. Comparison Operators
result in a value of true
, false
or null
.
The following tables show the usual comparison operators that can be used for
all simple data types:
Operator |
Description |
---|---|
< |
less than |
> |
greater than |
<= |
less than or equal to |
>= |
greater than or equal to |
= |
equal |
<> |
not equal |
!= |
not equal - same as <> |
If used in the WHERE Clause the following operators are valid in addition.
Operator |
Description |
---|---|
matches a part of the given value |
|
negates a condition |
|
matches a NULL value |
|
matches a Non-NULL value |
|
~ |
regular expression match |
!~ |
negated regular expression match |
between |
|