Morning Jim,

> ...
> How can I create the view so that the ORDER BY clause is variable?

Create the view without the order by, and select from it and specify an
order by as desired?

Create view myview .....;
...

Select <stuff> from myview
order by <desired_column>;

Oracle, FYI, doesn't allow views to be created with a variable order by
either.

Cheers,
Norman.


--
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767