>>I have a VIEW called myview and I want to ORDER BY.
>>How would I do this?
>
>In the view designer choose "Order By", or at run time you can
>create an index.
>Hope this help.

Thanks Lius for your answer... I want to ORDER BY using code with a VIEW.
If I already have a VIEW called myview, how would I do this code wise.
ex..
USE VIEW myview
ORDER BY fld_name

I know this does not work, but is there another way?