From the Right operand combo box, specify the right operand, if any, of an SQL predicate, expression, or logical expression.

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

If you are specifying the BETWEEN or NOT BETWEEN SQL predicate, specify the beginning value, the AND keyword, and the ending value in this field.

To apply a unary operator to the right operand you have specified, from the Unary operator pull-down menu, select Right operand and then the 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.

If you are specifying a SELECT statement, the list shows the columns in each of the tables and views you selected in the Tables/views list on the SELECT Details window. 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.

If you are specifying an UPDATE or DELETE statement, the list shows the columns in the table or view you specified in the Table/view field on the UPDATE Details window or DELETE Detailswindow. The column names are unqualified, and have the form <column name>. The list also shows any expressions you have added.

If an operator is not specified in the Operator field or the operator you have specified is IS NULL or IS NULL, Right operand is not available.