troubleshooting Question

add leading zero to a column

Avatar of jsctechy
jsctechyFlag for United States of America asked on
Microsoft SQL Server 2005
4 Comments2 Solutions683 ViewsLast Modified:
hi,
I have this select statement:
Select MILLAGE_CODE FROM TAX_ROLL
and this returns this:
700  
1100  
1840  
950  
950  
750  
2000  
2000  
1000  
1000  
2200

what i need to do is add as many leading zero as requiered to make it 5 characters long as follows:
00700  
01100  
01840  
00950  
00950  
00750  
02000  
02000  
01000  
01000  
02200  

how can i do this?
Thanks,
jsctechy
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros