Replace a " with a space in a string

[rleftw]

Can anyone tell me how to replace a " with a space in a string? I am doing an import of a text file and one of the fields has a value of Johnson "ABC" Company and I need it to be Johnson ABC Company. I am working in Access/2000 and I can not figure out a way to remove the character. I have tried using the Replace() function, but it has a problem replacing the " character.

 

[allanon]

I have Acc97 here and I cannot find a replace function BUT what you my try is something like:

replace(field, chr(34), " &quot

Sorry that I don't know the exact syntax for the function.

 

[rleftw]

Thank you allanon. I don't even think about using the CHR$(34)in the Replace() function. It works great.

Thanks for your help.