Skanda (10/8/2012)
Thank U Boss,It is looking great...
but i need every record should have a numeric and alpabet,
in present code, some records are only alphabetic....
In your original post, you said: -
Skanda (10/8/2012)
0001, 0002, ... , 0009, 000A, ... , 000Z, ... , 0010, 0011, ... , 001A, ... and so on till... , ZZZZ
"ZZZZ" doesn't have numeric values.