A couple of suggestions:
1. PADL the value with 0's before saving, so you'll have "01","02","03"......
2. Index on VAL() of the field.
HTH
>I need an index with the following secuence:
>
>"1" "2" "3" "4" "5" "6" "7" "8" "9" "10" "11" "12" ...
>
>the actual indexing method will do it like:
>
>"1" "11" "12" "2" "3" ...
>
>of course I'm talking about text data with numeric values
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.
