Operator usage context

Some operators are specific to a context.

There are operators only available in the SQL syntax, for example:

  • expr BETWEEN expr AND expr
  • expr comparison-operator SOME ( sub-query )

Other operators are only available in BDL code, such as:

Some operators are common to the BDL and SQL language:
Note: When using an operator such as IIF() or LIKE in an SQL statement, it is processed by your database engine. In SQL, the behavior and semantics may be slightly different from the BDL operator.

The following operators are only allowed in the FORMAT section of report routines: