Sorting numbers

[InfoNow]

I have a field that store procedure numbers. The procedure numbers are in a format as such: 2.1, 2.1.2, 2.10.100 ... and so on. I've tried to set the field as a number, but it won't let me. The only option was to create the field as a text field. This works fine, except when I want to sort the field. When I sort, it comes out as 2.1, 2.10.100, 2.1.2 and so on...I want it to be 2.1, 2.1.2, 2.10.100 and so on. Any idea(s) how I can do this?

TIA

 

[MichaelRed]

Either parse the single field into subfields, sort the subfields and 're-group' them for display purposes or make eadh of the fubfields "fixed-length", padded w/ leading zeroes.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over