Hi techies, I have searched so many "Replace" function topics, but there is something that I don't understand....I found some like this... Replace(strField, " ' ", " ' ' ") .... do anyone knows what's the use of replaceing ' with ' ' ? Tnx in advance.

That's to escape apostrophe signs usually in query strings. If you have a query string, let's say something like this:


There won't be a problem. The sql statement, after it's been merged with the variable name will look like this:


Which is a perfectly legit SQL statement. BUT if you had something like this:


It would crap out because of that apostrophe sign in O'Neil. So the SQL statement will look like this:


Which the database will think the apostrophe after the O is the end of the SQL statement and will wonder about the trailing "Neil" - how do you fix this? You escape the apostrophe sign by double it. So it would look like this:


And that's why that replace function replaces single apostrophes with doubles.