Brackets
Syntax
<bracket-expression> := '(' <sql-expression> ')'
Description
Brackets in SQL-Expression allow to control the evaluation-order of its sub-expressions. By encapsulating parts of your expression in brackets, you will force the database to evaluate the content of the brackets first before using their result with the outer operators. You also may encapsulate multiple brackets - then the expressions will be executed from the inner to the outer.
Examples
( 10 + 20 ) * 30
= 900
10 + 20 * 30
= 610
( CUSTOMER.FIRSTNAME IS NULL ) OR ( CUSTOMER.LASTNAME IS NULL )
