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
100a
thanks
>
>hi all,
>>i need to sort myfield with data as
>>1.5xzwa19
>>cwz1.2ab7
>>AB89-9-c
>>1c/xw.501f
>>99c
>>---------------------------
>>to be as
>>1c/xw.501f
>>1.5xzwa19
>>99c
>>AB89-9-c
>>cwz1.2ab7
>>
>>THANKS.>
>Use an index:
>
>INDEX ON myfield TAG myfield
>