It is the simple things that sometimes stump me.
I need to replace the following characters in text fields over many records.
Example.
2-5/8" Long Dimension
Needs to be
2-5/8"" Long Dimension
I need to replace all ("space) with
(""space)
So far everything I have tried, ignores the space following the double quote.
I have not even been successful in searching records to find which ones contain
the double quote followed by a space.
I have used (char(32)) in several configurations but with no luck.
Any thoughts appreciated.
Bob Thompson
LaPorte, IN
219-363-7441
