How can I replace local signs in a field by an access query

L

lilljl

I am using Access when importing text files (with addresses), I've created a
number of queries to handel the data but one problem remains. Sometime I
receive national German characters that is ok or might be received as a ; or
: sign, I would like to replace them with a two byte caracter as "oe" "ss"
etc, please help me to find the right command to replace the "bad" singns
that I recive, they can be anywhere in the field text.
 
C

Chaim

Use the Replace () function. Look at your Access Help under the Basic
Language Reference > Functions.
 
Top