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 |
|
meberg66219
Yak Posting Veteran
65 Posts |
 Posted - 2010-09-20 : 17:18:55
|
| I have three columns that I am trying to write a statement to remove any leading or following spaces as well as any carriage returns.All Three columns are varcharLastName (25 Characters)FirstName (25 Characters)Addr1 (255 characters)I used the following to query for carriage returns or line feed:select charindex(dbo.syStudent.LastName,char(13)+char(10)) from dbo.syStudentWhat is currently happening is when the data from the columns is exported to an .XML the data that has leading or following spaces or un wanted carriage returns is not merging into Outlook for a clean mail merge file.Now I just need an update query for for char(13), char(10), ltrim and rtrim.Can anyone help me? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
meberg66219
Yak Posting Veteran
65 Posts |
Posted - 2010-09-21 : 09:29:54
|
| Thank you so much for all of the assistance. That seems to have resolved the issue. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Remove spaces and carriage returns from Columns