>Hi to all,
>
>do you know if it's possible to create a view with the order by clause setted runtime ? Can I use the ?paramter way like for where expression ? Example :
>
>CREATE VIEW vwTest AS ;
> SELECT field1, field2 FROM myTable ;
> WHERE field1 LIKE ?param1 + "%" ;
> ORDER BY ?orderkey
It's probably easier just to index the view...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.