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 |
|
cat_jesus
Aged Yak Warrior
547 Posts |
 Posted - 2001-10-09 : 10:57:09
|
| Is there a function that will allow you to remove leading characters from a varchar column or text string? I'm looking for something that will work similar to ltrim except with zeros instead of spaces. I've done the prerequisite searches and I am coming up empty. Has anyone else hit this problem?nevermindCONVERT(DECIMAL(8,2),field)CatEdited by - cat_jesus on 10/09/2001 11:11:30 |
|
|
|
|
|
remove leading zeros