> Like rudy pointed out, unless zipcode is the PK of zip_table, > this may update more than one record. sorry, maybe i wasn't clear whether zipcode is the pk is irrelevant it's using wildcards that will potentially select or update multiple rows rudy