String Manipulation

[Guest]

Dear All,

I have a string "abcdef/ghijkl" in which I want to replace "/" with a non
command character. For example "abcdef-ghijkl".

The "/" character may appear in any position in this string.

How do I trap the character and replace it.

Thank you in advance.

 

[Allen Browne]

Assuming Access 2000 or later, use the Replace() function.

You can do that in code, or in an Update query.

If you do run into problems doing this in an Update query in Access 2000,
see:
http://support.microsoft.com/?id=225956

 

[Guest]

Allen,

Thank you very muck have a great weekend.