Without adding an additional field to the schema of our Syteline (5.0.20) ERP application (Progress 9.1a), I would like to sort a table (item master) by the character field (item). Management would like to pad the field with preceeding zeros to get the sort to their liking - I am fighting tooth and nail!
Current sort order:
4111
411
Pad with zeros will produce (don't want to do):
0411
4111
Does anyone know if I can use the RECNO to sort my queries? I control the item number entry so 411 would always be before 4111.
Thanks in advance...
Bill
Current sort order:
4111
411
Pad with zeros will produce (don't want to do):
0411
4111
Does anyone know if I can use the RECNO to sort my queries? I control the item number entry so 411 would always be before 4111.
Thanks in advance...
Bill