Replace ; with , with Access Update Query

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.
mato01Asked:
Who is Participating?
 
Gustav BrockCIOCommented:
This will do:

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

/gustav
0
 
MINDSUPERBCommented:
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
0
 
hnasrCommented:
"The problem is that it deletes the whole field."
What was your query's sql?
0
 
mato01Author Commented:
Perfect.  Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.