Trying to removes spaces between initials in sql
<p>I have a column that contains a persons name and I need to extract it to pass to another system but I need to remove the spaces but only from between the initials
for example I might have</p>

<p><code>Mr A B Bloggs</code> and I want <code>Mr AB Bloggs</code> or</p>

<p><code>Mrs A B C Bloggs</code> and I want <code>Mrs ABC Bloggs</code></p>

<p>As there are millions of records in the table I wont know how many initials there are or indeed if there are any initials. All I know is the prefix (Mr, Mrs etc) will be more than 1 character and so will the surname. I've tried using <code>trim</code>, <code>replace</code>, <code>charindex</code> but obviously not in the right combination. Any help would be appreciated.</p>