I would like to replace (or remove) a newline character in a TSQL-string.
Any Ideas?
The obvious
REPLACE(@string, CHAR(13), '')
just won't do it…
newlinetsql
I would like to replace (or remove) a newline character in a TSQL-string.
Any Ideas?
The obvious
REPLACE(@string, CHAR(13), '')
just won't do it…
Best Answer
Actually a new line in a SQL command or script string can be any of CR, LF or CR+LF. To get them all, you need something like this: