update cartruckdata set Chassis = 'Truck' where Exact_ID like '%bed%' --- must do me second update cartruckdata set Chassis = 'Truck-king' where Exact_ID like '%king ...

You can update one or more rows of a table through a view, with some restrictions. See Updating PROC SQL and SAS/ACCESS Views ... for a description of CASE expressions. To add, drop, or modify a ...

Adds columns to ... from an existing table. Restriction: You cannot use any type of view in an ALTER TABLE statement. Restriction: You cannot use ALTER TABLE on a table that is accessed via an engine ...

Returns a Boolean value that indicates whether an INSERT or UPDATE attempt was made on a specified column of a table or view. UPDATE() is used anywhere inside the body of a [!INCLUDEtsql] INSERT or ...