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 |
|
scelamko
Constraint Violating Yak Guru
309 Posts |
 Posted - 2007-06-20 : 20:20:26
|
| Guys,When csv file was imported it was attached with "return charecter" at the end. I am not able to remove return charecter since trim function doesnt seem to work. Is there any way to remove return charecter from the coiumn.Thanks |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-06-20 : 21:10:24
|
REPLACE(col, CHAR(13), '')
KH |
 |
|
|
|
|
|
Replacing Return Charecter