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]

Here is the answer

update [Record_Retentio n].[dbo].[Records]
set contents = replace(content s, '''', ' ')
where format='L' and status='Destroy ed'