6 Replies Latest reply on Jul 13, 2012 8:39 AM by erickaczmarczyk

    sorting number / letter issue

    erickaczmarczyk

      I am working on an inventory database where each item is assigned a unique number.

      The naming system includes a letter prefix, followed by a number.

       

      Right now with field type as number or letter, it sorts as:

       

      JS.1

      JS.10

      JS.100

      JS.2

      JS.20

      JS.200

       

      I am looking to sort it as:

       

      JS.1

      JS.2

      JS.10

      JS.20

      JS.100

      JS.200

       

      I would prefer to do this somehow without adding zeroes to before the number because all the objects are phsyically numbered this way already.

       

      Any suggestions would be greatly appreciated!

       

      Thanks!