Web Development

You could put together a little web app using PHP or ASP that would query the DB, replace the quotation marks and then do a replace on the data. I've done similar tasks that way.

You'll also need to fix the code that allows the quotation marks to be entered into the DB in the first place or else it'll be a recurring problem.

hai.
as u havn't mentioned whether the table belong to oracle/any other stuff.There is an sql function REPLACE. U can use it to solve. U have to create a new table with quot.mark cleared data then drop the orignal table and then recreate the orignal table with the create table as select sql. i can give u a small sample to create the new table without quot.mark. CREATE TABLE <Dest.Table> AS SELECT REPLACE (COST,'"','') COST FROM <source table>

This question was closed by the author