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 |
|
raky
Aged Yak Warrior
767 Posts |
 Posted - 2009-12-20 : 06:33:03
|
| Hi iam having problem with removing leading empty space..for example just check thisdeclare @i varchar(100)select @i = ' © 1998 Municipal corporation.'select @i 'originalValue',ltrim(@i) 'ModifiedValue'but iam still seeing leading space under ModifiedValue columnPlease suggest how can i remove leading empty space??expected output isModifiedValue:© 1998 Municipal corporation. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-12-20 : 08:55:26
|
I have tried your example via copy and paste.The results: © 1998 Municipal corporation.© 1998 Municipal corporation. This looks ok for me...
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
Ltrim issue