Operators

FDO API

 
Operators
 
 
 

The following operators are special characters common to SQL and most programming languages:

BinaryOperations

These binary operations are available:

+ Add (for compatibility with SQL string concatenation may also be defined using “||”)

- Subtract

* Multiply

/ Divide

UnaryOperations

These unary operation are available:

- Negate

Comparison Operations

These comparison operations are available:

= EqualTo (EQ)

<> NotEqualTo (NE)

> GreaterThan (GT)

>= GreaterThanOrEqualTo (GE)

< LessThan (LT)

<= LessThanOrEqualTo (LE)

Operator Precedence

The following precedence is shown from highest to lowest:

Negate NOT

Multiply Divide

Add Subtract

EQ NE GT GE LT LE

AND

OR