title: Remove inner white spaces in text data with SQL
body: <p>All I have what seems to be a pretty straight forward question, that I haven't been able to figure out.  For example, if I have a text string like <code>T6L 7H5</code>.  Using SQL I need to remove the inner white space from this string so that it displays like <code>T6L7H5</code>.</p>
  
  <p>Things to consider:</p>
  
  <ul>
  <li>Teradata (v.13.10) is my RDBMS, so <code>REPLACE('T6L 7H5', ' ', '')</code> is not an
  option here.</li>
  <li>On this particular server I am a business user w/ very limited
  permissions so creating a UDF is not an option either.</li>
  </ul>