community.borland.com

Article #25105: A Listing of Interbase-specific, and ANSI 92 SQL Standard Arithmetic Operators

Problem:
A Listing of Interbase-specific, and ANSI 92 SQL Standard Arithmetic Operators

Solution:
The information in this article applies to:
  * InterBase v4.x
  * InterBase v5.x

The chart below lists the operators supported in InterBase and their order of precedence: 

Operator		Precedence	Explanation
------------------------------------------------------------------------------------------------------------------
=, ==		Highest	Equality operations are evaluated 
			before all other comparison 
			operations.
<>, !=, ~=, ^=	                             _	
>		_	
<		_	
>=		_	
<=		_	
!>, ~>, ^>		_	
!<, ~<, ^<		Lowest	Not less than operations are 
                                                                                        evaluated after all other comparison 
                                                                                        operations.

This chart can also be found in the online help for InterBase.


The ANSI 92 SQL Standard reserves these operators:

  = <> > < >= <=


These operators are InterBase-specific and are not part of the ANSI 92 SQL Standard:

  == != ~= ^= !> ~> ^> !< ~< ^<  

Last Modified: 27-SEP-00