Hola Emmanuel ---

Use the following as your index expression (assuming the field name is called "idvalue"):

INDEX ON PADL(ALLT(idvalue),2,"0")

This will create an index where the single-digit values are interpreted as 01,02,03 and will be ordered correctly.



>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