can't replace "

hey all,

I get errors when trying to insert double quotes into the database (which is expected), but how do i get around it?

I am already replacing single quotes (') with two singles:

Replace(input, " ' "," '' ")

but when i try to replace double quotes it doesn't like it

Replace(input," " ", " '' ") here i am replaced a double quote with two singles, it looks unclear here.

How do i solve this problem? surely it's a common one.

cheers

Replace(input, " " " ", " " " " " ") '<- spaces added for readability