Other times, you may want to change certain rows based on the value of a particular column. The SET clause specifies the columns to update and their new values, and the WHERE clause specifies the rows to update.
UPDATE Customers SET LEFT(Phone,3) = ‘978’ WHERE LEFT (Phone, 3) = ‘508’