>>check Tom's article in the last VFUG newsletter
>>
>>Arnon
>>
>>>
>>> I have a VIEW called myview and I want to ORDER BY.
>>> How would I do this?
>>>
>
>Hi Arnon... Tom's article only talks about INDEX and not ORDER BY.
>I would like to do something like this:
>USE VIEW myview
>ORDER BY fld_name
>I know you can not do that..

if you can't use order by, why don't you use tom's method?