The UPDATE Statement

Contact Us or call 1-877-932-8228
The UPDATE Statement

The UPDATE Statement

An UPDATE statement is used to change data in a table and includes a SET clause to specify the columns to be updated.

Code Sample:

FROM regions 
WHERE region_name LIKE 'A%a%a';

UPDATE regions 
SET region_name = UPPER(region_name) 
WHERE region_name like 'A%a%a';

This update statement changes the region name to upper case for regions that have three A's in them.