Hi friends,

  I have a field like alpha numeric(03SK0001)
in the next time i have to retrieve last 4 digits and increment and concatenate to left 4 digits. When i do it becomes 03SK2
How can i preserve the leading zeros after math.(like 03SK0002)

Thanx in advance

let's assume that after doing the increment u have a variable called number which holds the incremented value.

'incremented value
number=2

'now we just add "leading zero's" until we
'reached the desired length of 4
do while len(number)<4
    number="0"&number
loop
'now the value of number is "0002"

this u can add to your original string again

hope this helps

Greetz,

Harold

Rather than concatenating in a loop, you can do:

intNumber = 2
strResult = Right("000" & intNumber, 4) ' gives 0002


intNumber = 200
strResult = Right("000" & intNumber, 4) ' gives 0200

Cheers
Ken

Microsoft MVP - Windows Server (IIS)
www.adOpenStatic.com

indeed a bit more efficient