We help IT Professionals succeed at work.

How to fill zero in the left to get a varchar(10)?

Dnx_7
Dnx_7 asked
on
Medium Priority
1,902 Views
Last Modified: 2009-07-29
Hi experts,

i would like to fill a varchar(10) with "0"

eg i have this varchar : "123"

so i would like to create such a string : "0000000123"

can you help me?

regards
Comment
Watch Question

AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009

Commented:
SELECT RIGHT ('0000000000'+@urVriable, 10)
Database Consultant
CERTIFIED EXPERT
Top Expert 2009
Commented:
SELECT RIGHT (replicate('0',10)+'123', 10)

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
thank you, very nice solution!
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.