Expression Builder wizard - Searched CASE Expression page

Use this page to build a searched CASE expression by adding WHEN and ELSE clauses to the expression.

The WHEN clauses contain Boolean search conditions that are evaluated. For example, CREDIT_LIMIT > 3000.

Build WHEN-THEN clauses, add an ELSE clause, or both
Use the rows in this grid to create the WHEN clauses and the optional ELSE clause of the CASE expression. To add a WHEN clause, click Add WHEN Clause. To remove a WHEN clause, right-click the clause and then click Remove WHEN Clause on the pop-up menu.
CASE
Shows whether the row contains a WHEN clause or an ELSE clause. If the row is an additional operand for the search condition, an ellipsis is shown in this cell.
Expression
Use this cell, together with the Operator cell and the second Expression cell, to specify the search condition. Type a value, select a column from the list, or click Build Expression to use the Expression Builder wizard to create the expression.
Operator
Select the operator that you want to use in the search condition.
Expression
Use this cell, together with the first Expression cell and the Operator cell, to specify the search condition. Type a value, select a column from the list, or click Build Expression to use the Expression Builder wizard to create the expression.
AND/OR
If the WHEN clause that you are defining contains a compound search condition, select the logical connective between the operands. A new row is added for you to specify the next operand in the search condition.
THEN
Specify the value that should be returned if the WHEN search condition evaluates to true. Click Build Expression to use the Expression Builder wizard to create the THEN expression.
Add ELSE clause
Select this check box to add an ELSE clause to the grid. The ELSE clause is used if none of the WHEN clauses evaluates to true. In the Expression cell of the ELSE clause, specify a value expression. Select a column, type a value or an expression, or click Build Expression to create a more complex expression. To remove the ELSE clause, clear this check box.
Preview of CASE expression
Shows the searched CASE expression that you have created.
Related tasks
Creating expressions in the Expression Builder wizard
Editing expressions in the Expression Builder wizard
Replacing expressions in the Expression Builder wizard

Feedback