Replace Letters

  • Thread starter Thread starter Dimitris
  • Start date Start date
D

Dimitris

Hello. I need to replace letters in a word. For example replace the letter
"M" in the word "SMITH" with "L" so it will become "SLITH".
I have a field named "ALLAGI" of table "PNK1" and I want all the "M" letters
in that field no matter if they are in the beggining, middle or end of the
word to be changed. If there are 2 "M" letters in a word etc. I want both of
them to change.

Thank you in advance.
Dimitris
 
Hello. I need to replace letters in a word. For example replace the
letter "M" in the word "SMITH" with "L" so it will become "SLITH". I
have a field named "ALLAGI" of table "PNK1" and I want all the "M"
letters in that field no matter if they are in the beggining, middle or
end of the word to be changed. If there are 2 "M" letters in a word etc.
I want both of them to change.

Thank you in advance.
Dimitris
Click to expand...

If using Access 2000 or newer there is a Replace() function. Use that in
an update query. As usual with update queries I suggest testing on a
copy of your table.
 
Back
Top