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 |
|
KnooKie
Aged Yak Warrior
623 Posts |
 Posted - 2002-01-15 : 13:55:43
|
| I know there is LTRIM and RTRIM but is there a TRIM or something equivalent as in VB which will TRIM both ends at once ??many thanksPaul |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-01-15 : 14:03:52
|
| I don't believe so, but you can do them both at once like:LTRIM(RTRIM(string))-Chad |
 |
|
|
Swede
Yak Posting Veteran
74 Posts |
Posted - 2002-01-16 : 03:52:23
|
TRIM(string) trims from left and right at the same time... in VB that is... hehe... maybe it's of no relevance though  =====================================Why not try and do the impossible? |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-01-16 : 06:44:10
|
| Nope, sorry Swede, not in SQL.Chad has it right.Damian |
|
|
|
|
|
|
TRIMming