Select Query--> Expression Builder to access a submenu, or palette, of SQL elements for building an SQL expression. The Expression Builder palette contains common elements such as:
A template for each expression element you select is inserted into the query document. This provides the fundamental structure for you to substitute parameters for the query in place of the <expression>. For example,
CASE <expression> WHEN <expression> THEN <result-expression> ELSE <result-expression> END