Say you want to search the customer table for sales tax code 1 'AZ' and replace with sales tax code 1 'AZ2'

 

Here is the SQL statement:

 

Update "customer" set sales_tax_code_1 = 'AZ2' where sales_tax_code_1 = 'AZ'