Replace characters in data

[Walter]

Does anyone know of a function that can replace a
character based on one specified.

Eg
I some dates that have been delimited by .
21.11.03

Can I run an udapte to change . to /
21/11/03

Regards,

Walter

 

[Duane Hookom]

Maybe the Replace() function?

 

[Greg Kraushaar]

MSA2K on
Look up Replace in the Help file

 

[Guest]

Can you say "Undefined Function REPLACE" in MsAccess 2000 and earlier?

Any other solutions?