Sorting a list box "numerically"

[EMJULIAN]

I have a list box that gets populated with items that are characters but are numbered (i.e. "1-item a", "2-item b", etc.). The SORTED property on the list box puts them in order 1,10,11,2,3,4. Is there another way to sort a list box that will sort the numbers 1,2,3...10,11,12?

Thanks
Eve

 

[mspratt]

Hi Eve,

Something similar to this may work for you:
SORT ON PADL(myfield,3,0)

Regards,

Mike

 

[TamarGranor]

Can you create the items with appropriate leading blanks?

Tamar