replace a char in a string 1

[tyris]

hi all,

i searched how to do this, but found only a begin of response ...
could you help me ?

i need to search the character "'" in a string, and each time i find one, to
replace it with an other character.

i know that i cant use len() to get the length of the string, that i can use
InStr() to compare it with the "'" character ... and then, how to do ?
advices are welcome
best regards,

elise
Best regards,
Elise

 

[dsi]

If you want to replace a single quote with, let's say, an asterisk:

MyString = "Some Text ' blah blah ..."
NewString = Replace(MyString,chr(39),"*&quot