• Right click on the table and and generate the select statement to a query window and then edit the 3 or 4 columns that require the replace function. You won't have to type it all out this way.