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 |
|
shanmugaraj
Posting Yak Master
219 Posts |
 Posted - 2006-04-11 : 09:30:30
|
| In one of the column which i import , all records have the This means the enter button on that line... how to replace or remove Eg ::Month @ 7:30 p.m. Location: ass nue Westmont |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-04-11 : 09:35:15
|
| select replace(col,char(13),'') from yourTableMadhivananFailing to plan is Planning to fail |
 |
|
|
shanmugaraj
Posting Yak Master
219 Posts |
Posted - 2006-04-11 : 09:37:43
|
| Not Working ......select replace(local_notes,char(13),' ') from localsNot Working ...... |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2006-04-11 : 10:46:27
|
| Then...use REPLACE to get rid of the |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2006-04-11 : 11:09:51
|
| I think the main problem is establishing what that character is. It's appearing as a Male Sign (U+2642) on my screen, which doesn't seem very likely.Hmm, when I cut and paste it, I'm getting control-K, so perhapsREPLACE(local_notes, CHAR(11), ' ')would work. |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2006-04-11 : 15:23:25
|
quote:
Originally posted by shanmugaraj
In one of the column which i import , all records have the This means the enter button on that line... how to replace or remove Eg ::Month @ 7:30 p.m. Location: ass nue Westmont
I'm not familiar with that location: "ass nue Westmont". Is that anywhere near Butt e Montana?btw,I wouldn't have even looked at this thread but the "Remove" topic intrigued me.  Be One with the OptimizerTG |
|
|
|
|
|
|
|
|
remove