[Forum] Replace a word containing " character

[Greight]

Hi.
I want to run a query by which I can replace this DBOX="1" with DBOX, but when I try to run it I get database error and I think it is because of " character. What query can I run to do the trick?

Sorry I have posted this on vb.org as well but after two days no one answered

[Andy]

I've tested this and it works. But just in case, please backup your database first.

UPDATE post SET pagetext = REPLACE(pagetext, 'DBOX="1"', 'DBOX')

[Greight]

Yes, that worked. Thank a million buddy.