How eliminate the tab space in the column in SQL Server 2008

Question

I have an column with email in table customer where the data in the column contains special character  TAB  When I do a select  I need to remove the TAB space from that column   Means there is an empty TAB space followed by the EmailID      xyz com  I tried using the LTRIM and RTRIM but that does not work here

User · Answer

UPDATE Table SET Column   REPLACE Column  char 9

User · Answer

See it might be worked -------  UPDATE table name SET  column name replace column name             Remove white space  UPDATE table name SET  column name replace column name    n         Remove newline  UPDATE table name SET  column name replace column name    t         Remove all tab  Thanks Subroto

User · Answer

Try this code  SELECT REPLACE  Column   char 9       From  dbo Table     char 9  is the TAB character

User · Answer

Use the Below Code for that  UPDATE Table1 SET Column1   LTRIM RTRIM REPLACE REPLACE REPLACE Column1  CHAR 9        CHAR 10        CHAR 13

[sql-server-2008] How eliminate the tab space in the column in SQL Server 2008

Examples related to sql-server-2008