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

Hello,
  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.
Luke

 
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
Default

Use the Format() method

EX:

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


Jim






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.