Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2008-01-25 : 13:01:15
|
| I have the following;108;111;100;103;105;110;103;13;10;13;10;13;10word is lodging I see the 13 as ascii and the 10 as line feed but when i runUPDATE TABLEASET COLUMN_TEXT = REPLACE(REPLACE(REPLACE(COLUMN_TEXT, CHAR(10), ''), CHAR(13), ''), CHAR(9), '')It is just not removing these charactersAny suggestions |
|
|
|
|
|
Char 13 remove