From the Left operand combo box, specify the argument of a function or the left operand of an expression.

If the left operand is a value, type the value in the field.

If you are specifying a function, specify the argument and then apply the function you want to use.

To apply a function or unary operator to the left operand you have specified, from the Unary operator pull-down menu, select Left operand and then the function or unary operator you want to apply.

To add the expression you have specified to the Left operand and Right operand lists, select Add to operand lists. The expression you have specified is displayed in the Expression field.

The list shows the columns in each of the tables and views you selected in the Tables/views list on the SELECT Detailswindow. The column names are fully qualified, and have the form <table or view name>.<column name>. The list also shows any expressions you have added.