Updating Field with -'s In

[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

 

[Ken Snell [MVP]]

Use the Replace function (ACCESS 2000 patched and higher versions).

UPDATE TableName
SET FieldName = Replace([FieldName], "-", "", 1, -1, 1);

 

[Marshall Barton]

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.

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