Character find and replace

[amps]

Hi Folks,

I'm trying some character manipulation in SQL Server 2000.

Say we have a table data with a field data_text. In the data_text field we have data like

"How`s you then"

Can anyone let me now how I can update this text field so I can replace the ` with a '

[zamkam]

SET data_text = REPLACE(data_te xt,'`','''')

The last argument is 4 (four) consecutive single quotes, with no spaces. In general, when you want to specify a single quote in a string, use two quotes.