To type the SQL statements for a query you must first open a new query document. To open a new query document select Create --> SQL Query. The query window opens. You can type the SQL statements directly in the active query window.
You can use the Expression Builder to help you build conditional expressions that can be included in the SQL statements for your query. Click the 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