We help IT Professionals succeed at work.

Replace ; with , with Access Update Query

mato01
mato01 asked
on
I'm trying to replace all ; (semi comma)  within  a field with , (comma) with a update query.  The problem is that it deletes the whole field.

I need to update the Description field in an Access Table.

From Original
Texas; Florida; or Michigan with

To New
Texas, Florida, or Michigan.
Comment
Watch Question

I may suggest to just open the table, then Select the Description Column and do the Find and Replace feature built within Access. You can use Ctrl+H.

Sincerely,
Ed
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
This will do:

UPDATE
  tblYourTable
SET
  tblYourTable.Description = Replace([Description],";",",");

/gustav
Hamed NasrRetired IT Professional

Commented:
"The problem is that it deletes the whole field."
What was your query's sql?

Author

Commented:
Perfect.  Thanks