title: Remove all spaces from a string in SQL Server
body: <p>What is the best way to remove all spaces from a string in SQL Server 2008?</p>
  
  <p><code>LTRIM(RTRIM('  a b '))</code> would remove all spaces at the right and left of the string, but I also need to remove the space in the middle.</p>