Wrox Programmer Forums
ASP.NET 2.0 Professional If you are an experienced ASP.NET programmer, this is the forum for your 2.0 questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old February 21st, 2006, 11:52 AM
Registered User
Join Date: Jan 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to hawkfb63
Default Integer of specific length

  I am hoping somebody can help me out. I am trying to get a label to display an integer I get from a query. I need the label to be 3 digits long, so if the query returns the number 4, I want it to convert it to 004 etc. There is also the possiblility that the query will return a 2 or 3 digit number, so I cant just add 2 "0s" in front of it. Any help would be greatly appreciated.

Old February 22nd, 2006, 03:30 PM
Friend of Wrox
Join Date: Nov 2003
Posts: 1,348
Thanks: 0
Thanked 5 Times in 5 Posts

Use the Format() method


Dim i As Integer
i = 23
Response.Write(Format(i, "00#"))


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search specific data from specific columns yogeshyl SQL Language 1 January 16th, 2008 11:12 AM
Copy specific data in specific cells of sheet2 yogeshyl Excel VBA 1 May 14th, 2007 07:40 AM
text vs integer paul20091968 Access VBA 2 February 13th, 2007 10:50 PM
Integer Problem needelp Access VBA 3 October 27th, 2006 09:47 AM
Testing for integer MattLeek Excel VBA 8 March 7th, 2004 09:15 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.