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 |
|
BitShift
Yak Posting Veteran
98 Posts |
 Posted - 2007-05-18 : 16:03:22
|
| There is ltrim and rtrim, but what if i want to remove spaces from both ends of a string variable. Do I need to use both functions ? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-18 : 16:09:10
|
| yup._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-05-18 : 17:29:28
|
make sure you apply them in the correct order.
www.elsasoft.org |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-05-18 : 17:39:36
|
quote:
Originally posted by jezemine
make sure you apply them in the correct order.
www.elsasoft.org
How does the order matter Jesse?Dinakar NethiSQL Server MVP************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-05-19 : 00:55:03
|
| I am also interested to know how it matters MadhivananFailing to plan is Planning to fail |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-05-20 : 16:10:32
|
it doesn't of course. that was supposed to be a joke.
www.elsasoft.org |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-05-21 : 00:10:57
|
quote:
Originally posted by jezemine
it doesn't of course. that was supposed to be a joke.
www.elsasoft.org
Then you should have used [joke] comment[/joke]  MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
is there not a trim function ?