Small Calculation - Urgent help

Please give us the coding to genarate this calculation.

00001,00002,00003..................00009,00010,00011,..........00100

Najath

Quote:

---

Originally posted by Najath
Please give us the coding to genarate this calculation.

00001,00002,00003..................00009,00010,00011,..........00100

Najath

---

if using SQL server try this
assuming empid is prefix with char E0001.

select replicate('0',(5-len(right(em_id,4)),(cast(right(em_id,4) as numeric)+1) from emp

In VB, you can use Format to make the string have the 5 digits you need, like this:

VB Code:

Private Sub CommandNumbers_Click()
Dim myNum As Integer
For myNum = 1 To 100
    Debug.Print Format(myNum, "00000")
Next
End Sub

Hi Jim

Hey man it's working. Thanks a lot.

Najath

:) :) :) :)