How remove hyphens from field data in a table
I have a table that has a text field. The data in this field for all records has hyphens. For example:
01-0209-090-1030
I want to remove the hypens using a query so that the end result, for example, is 0102090901030.
How can I do this?
01-0209-090-1030
I want to remove the hypens using a query so that the end result, for example, is 0102090901030.
How can I do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.