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 |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2008-02-27 : 12:17:39
|
| Hey, everybody,I need your help on figuring out what is this invisible character in one of my data column.The file is from IBM DB2 as text. I am comparing the data with the one in SQL server. There is one white space at the end of the column I couldn't get rid off.The text strings from both side look idential except the DB2 one has a "space" at the end.The len() show it's 13, while the sql one is 12. However, the rtrim()/ltrim() did not get rid of it.This column is at the end of the row. So it could be CR or LF. To use padindex or stuff functions, I need to know what is this stuff.Talking about working hard for "NOTHING".Thanks! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-27 : 12:21:39
|
| might be this:-http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=96649 |
 |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2008-02-27 : 12:26:34
|
| great, thanks!I have used substring to clean it out.Your link has good stuff, and I will save it for future use. Btw, does any one know any third party tool that does a decent job of profiling data? |
|
|
|
|
|
|
what is that invisible character?