replace " (quotes) in field with update query

[cdck]

I have a database populated through an import from an older system. The description field often includes the " symbol, which in this case means inches, somewhere in the middle. Of course, it meant a whole other thing to the SQL database, so during the import any occurrence of " got turned into "". I need to run an update query that will replace any occurrence of "" with -IN.

Example of the intended result:

21"" monitor with double bezel

should become

21-IN monitor with double bezel

How do I accomplish this?

Cheryl dc Kern

 

[gmmastros]

Make sure you have a good backup before running this.

Update Table
Set    Field = Replace(Field, '""', '-IN')

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[cdck]

Thanks! Will run the query in the morning - IT Director is gone for the day. I'll let you know how it goes!

Cheryl dc Kern