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.
This question is related to
sql-server-2008
Try this code
SELECT REPLACE([Column], char(9), '') From [dbo.Table]
char(9) is the TAB character
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
UPDATE Table SET Column = REPLACE(Column, char(9), '')
Use the Below Code for that
UPDATE Table1 SET Column1 = LTRIM(RTRIM(REPLACE(REPLACE(REPLACE(Column1, CHAR(9), ''), CHAR(10), ''), CHAR(13), '')))`
Source: Stackoverflow.com