D
Don Hicks
Hello,
Is there an Access equivalent of the str_replace() function?
Here's my dilemma:
In an Access '97 table, I have a text field containing item descriptions.
The process that imported the data from another database has inserted a
"~;~" (minus the quotes) in random locations within most of the descriptions
(with multiple instances of the insertion in a few of the descriptions).
I'd like to run a query from that data, removing the "~;~" or replacing it
with spaces.
Is there a way to do that?
Sincerely,
Don Hicks
Portland, Oregon
Is there an Access equivalent of the str_replace() function?
Here's my dilemma:
In an Access '97 table, I have a text field containing item descriptions.
The process that imported the data from another database has inserted a
"~;~" (minus the quotes) in random locations within most of the descriptions
(with multiple instances of the insertion in a few of the descriptions).
I'd like to run a query from that data, removing the "~;~" or replacing it
with spaces.
Is there a way to do that?
Sincerely,
Don Hicks
Portland, Oregon