Partial Update Query Using the *

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to run a query that updates a portion of the information in a record.
This would be like a the find/replace feature. Only i want to automate it
for several different conditions. Like Company to Co, Inc. to Inc

For Example the query would change ABC Incorporated to ABC Inc

The query would do this for about 500 records.

I can get the criteria with no problem using the "*". However when I put the
* in the "update to" field, i get a syntax error.

Please help
 
First Back up your data.
You can use the replace function to replace certain string to another.

Update TableName Set FieldName = Replace([FieldName],"Incorporated","Inc")
 
Back
Top