Delete Specific Characters From Text

[Jeff Monroe]

I am trying to create an Update Query that will strip out certai
characters from a string in a text field (specifically hyphens an
slashes) while leaving the rest of the data in the record alone. Th
characters do not exist in all records and they are located i
different positions in the field.

Examples: 1234-01, 12345-01, ABC/D, WX-YZ.
Desired Result: 123401, 1234501, ABCD, WXYZ.

Thanks for any help.
jef

 

[Jeff Monroe]

MG:

Thank you very much for the tip. It worked exaclty as I needed. You
saved me hours of manually deleting the characters I don't want.

Jeff