Updating Field with -'s In

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

Guest

Hello, I have a field that comes to us with dashes in it in the format
0000-00000-0 and I would like to run an update query on the field to delete
the the dashes. Can someone explain the simplest way to do this.

Thanks so much,
IEJ
 
Use the Replace function (ACCESS 2000 patched and higher versions).

UPDATE TableName
SET FieldName = Replace([FieldName], "-", "", 1, -1, 1);
 
Hello, I have a field that comes to us with dashes in it in the format
0000-00000-0 and I would like to run an update query on the field to delete
the the dashes.
Click to expand...


UPDATE thetable SET thefield = Replace(thefield, "-", "")
 
Back
Top