Cahnging one character in a text field

[blumash]

I would like to change part of a text field in a file , for example I have a field with text "H6rom " in this text thesecond character is "6" , I would like to change this "6" to "a" .

Thank's

 

[Stella740pl]

If you want to replace all instances of "6" with "a" in all records of the table, then you could do

REPLACE ALL MyField WITH CHRTRAN(MyField, "6", "a")

Is this what you need? If not, then please clarify.

 

[blumash]

Thank's stella740pl , it did the job & replaced all the "6" with "a".