Small Calculation - Urgent help

[Najath]

Please give us the coding to genarate this calculation.

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

Najath

[khalik]

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

[Jim Brown]

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

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

[Najath]

Hi Jim

Hey man it's working. Thanks a lot.

Najath