How to Replace Double Quotes

[cheynei]

Need to replace " with in. or escape it so it will work with my sql update and insert statements
I tried the following:
newstring = replace(oldstring, """", "in.&quot
which doesnt give an error, but doesnt replace the "
Also tried, which gives an error
newstring = replace(oldstring, """, "in.&quot

Thanks

 

[durug]

What do you mean is not working?
I just tryed newstring = replace(oldstring, """", "in.&quot
and the function is replacing doulbe quotes

To escape it use
newstring = replace(oldstring, """", "&quot