sql-server-2008

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

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.

Solution

  • Try this code

    SELECT REPLACE([Column], char(9), '') From [dbo.Table]

    char(9) is the TAB character