I tried
UPDATE TABLENAME SET COLUMNNAME = REPLACE(COLUMNNAME, '\t', '')
But I don't know how to write the TAB in t-sql
I tried
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), '')
I found the solution:
I 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)
You can put a tab character in the string, just press the tab key.
That will work, but it's not very readable.
In the beginning of my TSql sProcs, I often put
Declare @NL Char(2) Set @NL = Char(13) + char(10)
Declare @Tab Char(1) Set @Tab = Char(9)
etc...
Then you can use those declared variables anywhere in the rest of the proc without loss of clarity...