Order in Combobox

[Beany]

ive got a combobox that shows usernames in order....

but ive got usernames such as spare 1, spare 2, spare 3, spare 4, spare 5, spare 6, spare 7, spare 8, spare 9.....

but if i add spare 10 --> it shows spare 1, spare 10, spare 2, spare 3, spare 4, spare 5, spare 6, spare 7, spare 8, spare 9

how can i show spare 10 after spare 9???

[nico5038]

A character sort will need:
spare 01
spare 02
etc.
When you have > 99 spares you'll need:
spare 001
spare 002
etc.
Best solution is to "split" the field and record "spare" separate from the sequence number. When you use a numeric sort it will work as you want and when showing it to a use use:
select sparefield & " " & sparenumber as spareseq, ...

Nic;o)