Replacing an apostrophe with a space

[sc5502]

I want to replace an apostrophe with a space in a SQL field. I have tried this bit does not work:

 
Update [Record_Retention].[dbo].[Records]
Set    contents = replace(contents, ''''', ' ')
where status='Destroyed' and format='L';
 
 

What am I doing wrong? Thanks

[sc5502]

update [Record_Retention].[dbo].[Records]
set contents = replace(contents, '''', ' ')
where format='L' and status='Destroyed'