replacing all the ' in a table

Hi all

I need to remove all the ' in a table and i am having some problems with the script, any help would be great

Thanks

Richard

use the following replace statement,

Update tableName

set

ColumnName = Replace(Columnname,'''','')

Where

Columnname Like '%''%'

sql