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:

expr := expr
SFMT( expr [,...] )

Some operators are common to the BDL and SQL language:

IIF( bool-expr, true-expr, false-expr )
expr LIKE mask

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:

PAGENO
WORDWRAP