SQL builder Design pane - Set page

Use this page to specify a SET clause in an UPDATE statement.

The SET clause specifies which columns to update, and calculates new values for them.

unlabeled field
Lists the columns that are available to add to the SET clause. To add a single column, click it in the list, and then click >. To add multiple columns as a group, click the first column in the list, press and hold down Ctrl, click additional columns, and then click the Group Image of the group button button.
Update Column
Shows the columns and groups of columns to update. To remove a column or group from the list, click it and then click <.
Expression
To set the value of the column or group to other than the default value, type a value or expression, or build an expression. To build an expression, select Edit Expression in the list, and then press Enter.
Related tasks
Creating SET clauses in UPDATE statements in the SQL builder
Creating expressions in the Expression Builder wizard
Related reference
SQL builder for UPDATE statements

Feedback