" Charecter

[Max]

How can I delete this " from a feild.

eg:

"khkhkhkh"
kk"khkhk"

Thanks

 

[Douglas J. Steele]

UPDATE MyTable
SET MyField = Replace([MyField], Chr$(34), "")