Replace

[crmpicco]

This should be simple, but it's got me: how do you use 'Replace' to
replace double quotes? This won't work:

Replace(strString,""","'")

to replace the double quotes with singles, for instance. I just know I'm
missing something obvious here.

Thanks.

[Brandoe85]

Try this:

strSomthing = replace(strSomthing, chr(34), "'")

[oracleguy]

This should work as well but I didn't test it:

Replace(strString, """", "'")