Comparison operators

ISO Standard Operators

The comparison operators can be grouped into ISO standardised operators and non-standard variations. There are six ISO standard operators, as follows:

  • Equality (a = b). The equality operator returns true if the two compared values (a and b) are equal.
  • Less Than (a < b). This operator returns true when 'a' is smaller than 'b'.
  • Greater Than (a > b). This operator returns true when 'a' is larger than 'b'.
  • Less Than Or Equal (a <= b). This operator returns true when 'a' is smaller than 'b' or the two values are equal.
  • Greater Than Or Equal (a >= b). This operator returns true when 'a' is larger than 'b' or the two values are equal.
  • Not Equal (a <> b). This operator returns true if the two compared values (a and b) are not equal.

Non-Standard Operators

The second set of operators contains the non-standard variations. It is acceptable to use these operators but you should consider that statements that you create might not be supported on other ISO-compliant database management systems.

  • Not Equal (a != b). This operator returns true if the two compared values (a and b) are not equal. It provides the same functionality as <>.
  • Not Greater Than (a !> b). This operator returns true when 'a' is smaller than 'b' or the two values are equal. It provides the same functionality as <=.
  • Not Less Than (a !< b). This operator returns true when 'a' is larger than 'b' or the two values are equal. It provides the same functionality as >=.

{{opmerking.Naam}}:

{{opmerking.OpmerkingText}}

            

Saving your comment....

Naam is verplicht!
Email is verplicht!
Opmerking is verplicht!