UPDATE TABLENAME SET COLUMNNAME = REPLACE(COLUMNNAME, '\t', '')
But I don't know how to write the TAB in t-sql
The ASCII code for tab is 9; you could try
update tablename set columnname = replace(columnname, char(9), '')
In the beginning of my TSql sProcs, I often put
Declare @nl Char(2) = char(13) + char(10) Declare @tab Char(1) = char(9) etc...
Then you can use those declared variables anywhere in the rest of the proc without loss of clarity...
SELECT -- TRIM LTRIM(RTRIM(REPLACE(REPLACE(REPLACE(columnname, CHAR(9), ' '), CHAR(13), ' '), CHAR(10), ' ')))
You can put a tab character in the string, just press the tab key.
That will work, but it's not very readable.
I found the solution:
In T-SQL you do not escape characters, you paste or type them directly into the quotes. It works even for \r\n (carriage return, new line = you press enter)