2 Replies Latest reply on Jan 20, 2014 5:03 PM by jaag26hon

    How to create a range of value for initial and last serial number?

    jaag26hon

      Hello Guys,

       

      I am going to developed database to keep track of all the product serial numbers for the company I work for.

      Now, this is the situation. Each product comes in a 30 - 40 units-Box; on the outside the box there is a label

      with the initial and last serial number, and instead of entering the serial # one by one to the system, the user

      will have to just enter the first and last number in the script will generate the range of serial numbers.

      However, these serial numbers normally contain some letters in the middle. For example, XN130PA00042; when

      the numbers reaches its maximum value then the letters changes. For, example, XN130PA99999 ==>XN130PB00000

       

       

      Could please someone help me to create a script in which the user enter FROM: XN130PA99995 TO: XN130PB00025

      and the program will automatically gerenate range of 30 serial numbers ?