How to find a character in table of records and then replace it

[michellerobbins56]

Hi

Please can anyone tell me how to find a certain character in some records and then replace it with another. Basically I need to search my database records in a certain field and find any single quotes and replace them with ` instead. I can do this in ASP but I'm not sure how to do this in SQL (by using Query Analyser).

Thank you very much for any help and examples.

 

[bborissov]

UPDATE MyTable SET MyField = REPLACE(MyField,'''','`')
       WHERE CHARINDEX('''',MyField) > 0

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[michellerobbins56]

I'll try that out. Thank you very much for your help.