strip quotes from text or varchar fields 1

[CassidyHunt]

I am wondering if there is a simple way to go through a table and remove " or ' from a record if the it contains one of those items?

I am pulling this data into a webpage to populate a javascript array and have about 1200 records that some contain quotes that really mess up the array.

Thanks
Cassidy

 

[TonyGroves]

Sure:
[tt]
UPDATE tblname
SET
fld1=REPLACE(REPLACE(fld1,"'",""),'"',''),
fld2=REPLACE(REPLACE(fld2,"'",""),'"','')
[/tt]

 

[CassidyHunt]

That is great. Thank you.