SQL Server - replace multiple apostrophes with single apostrophe
<p>On my database I have had an issue with how I have escaped single quotes, resulting in them being doubled up every time a record is saved.   I have fixed this now, but I need to clean up the mess it has created.</p>

<p>So I was wondering what's the most straight forward to replace all instances of more than on apostrophe with a single one.   So for example replace ''''''' with '</p>

<p>There are many instances of varying numbers of them in the table.</p>