erickaczmarczyk

sorting number / letter issue

Discussion created by erickaczmarczyk on Jul 13, 2012
Latest reply on Jul 13, 2012 by 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!

Outcomes