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
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.