Use the Expression Builder to create expressions. You can type your expression directly into the Expression field, or you can use the fields and controls in the Expression Builder to build your expression.
To build an expression:
Use the Columns, Operators, and Case lists to select the components of the expression. Double-click on a particular column, operator, or case keyword to add it to the Expression field. Each item that you double-click is appended to the expression in the Expression field, so be sure to select items in the order that you want them displayed.
Add specific values to your expression. Type a value in the Value field, then click the checkmark to add the value to the Expression field.
To add a function to your expression:
Select a category from the Functions list. The list below the Functions field changes to display functions in the specified category.
Double-click on a function in the list below the Functions field.
The Function Parameters window opens. Select the format of the function and specify the parameter values.
Click OK. The Function Parameters window closes. The function and its parameters are displayed in the Expression field of the Expression Builder.
To add a constant to your expression:
Select a category from the Constants list. The list below the Constants field changes to display constants in the specified category.
Double-click on a constant in the list below the Constants field. The constant is added to the expression in the Expression field.
Use the following buttons to work with your expression:
Click And, Or, =, <>, (, and ) as needed to add those operators to your expression.
Click Clear to remove all input from the Expression field.
Click Undo to remove the last change that you made from the Expression field.
Click Redo to reverse the last change that you made in the Expression field.
After you complete your expression, click OK. The Expression Builder window closes.
If you were using the Expression Builder to create a column expression, the column expression is added to the Selected columns list on the Columns page.
If you were using the Expression Builder to create a row condition, the condition is appended to the Conditions field on the Conditions page.
If you were using the Expression Builder to create a group condition, the condition is appended to the Group conditions (HAVING) field on the Groups page.
Related information
Expression Builder - Fields and controls
Creating SQL statements with SQL Assist