If the WHERE clause includes a predicate, all the rows of the
    target table for which the predicate is true are modified.

    The columns named in the predicate must be columns of the target
    table or view. The target table cannot be named in a column
    select expression within the predicate.

    See the Predicates HELP topic for more information on predicates.