>Hi,
>I want to build a parameterized View that can change the "order by" clause, any idea ?
>
>TIA

There is no parameterizing of the ORDER BY clause. You could omit the oRDER BY clause and just index the view each time you open it. When you close the view the associated index file is also a temp file and disappears as well.

Stonefield Database Toolkit now has a feature that lets you define indexes for views and creates them automatically everytime you open the view with their OpenTable() function. Of course, there are many other useful tools that come with SDT as well. PUTM members also get a discount.