Before I spend time writing a function to replace a certain character in a string, does Access have a built in function, which I could pass a string, a character to replace, and the replacement character and get the modified string returned?

Thanks

Mike
EchoVue.com

__________________
Mike
EchoVue.com

If you had to replace an "_" or any type of character
see the replace function...

in an update sql statement you could ...

Replace([FieldName, "_", "")

this will replace the _ with nothing

or use the find/replace option in access

Jaime E. Maccou

Thanks!

The replace function should work nicely. I am having a problem with double quotes appearing in data that I am inserting using an SQL INSERT function. By parsing the string through Replace with, switching " with ', it should solve the problem.

Thanks again

Mike
EchoVue.com