title: Remove an unknown number of Spaces from String
body: <p>Our Item Description field can have a random number of spaces between text. I use <code>RTRIM</code> and <code>LTRIM</code> to clean the right and left sides of the column when pulling with SQL, but this doesn't address the unnecessary spaces between words.</p>
  
  <p>I tried creating a Formula <code>TRIM({Command.ItemDesc})</code> but this has not removed the extra spaces. Is there a way to address this in Crystal or SQL 2016?</p>