title: How eliminate the tab space in the column in SQL Server 2008
body: <p>I have an column with email in table <code>customer</code> where the data in the column contains special character: TAB</p>
  
  <p>When I do a select, I need to remove the TAB space from that column.</p>
  
  <p>Means there is an empty TAB space followed by the <strong>EmailID:     xyz.com</strong></p>
  
  <p>I tried using the <code>LTRIM</code> and <code>RTRIM</code> but that does not work here.</p>