>hi,
>thank you for reply,
>i see the result is..
>1.5xzzwa19
>1c/xw.501f.....after index it must be
>------------------------------
>1c/x...
>1.5x.....
>----------------------------
>if i have ex..
>100a
>11a
>10a
>1a....after index it must be
>----------------------
>1a
>10a
>11a
>100aYour sorting scheme is non-standard (e.g. not ASCI indexing) as you want
1a
10a
11a
100a
In that case unfortunately you would have to add another field (column) with the sorting order to tell it how to sort as ASCII will always put 10a before 1a.