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 |
|
joelseverich
Starting Member
34 Posts |
 Posted - 2009-09-29 : 17:14:52
|
| hiis there a way to trim fields in select statement |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
dattatreysindol
Starting Member
20 Posts |
|
|
dattatreysindol
Starting Member
20 Posts |
Posted - 2009-09-29 : 17:41:40
|
| Please use LTRIM(RTRIM(FieldName)) instead of just RTRIM(FieldName).RTRIM(FieldName) removes the extra spaces at the end of the word. By using LTRIM(RTRIM(FieldName)) we can ensure to remove the extra spaces at both ends.Hope that helps!Dattatrey Sindolhttp://mytechnobook.blogspot.com/ |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Trim fields