Hello Adam,

> What is it you are trying to accomplish with the stored procedure? If
> you are only interested ordering the reservation by start time, then
> you could use a much simpler approach.

This is a very simplified case of trying to reproduce the problem.

> I also wasn't aware that you could use a stored procedure inside an
> order by clause, and am struggling to find an occasion that you would
> actually want to. Order by accepts a list of field names rather than
> values.

What I am trying to do is to order the reservations on a value that is
located in a string that can be addresses using a UDF.
The SP is used to find the FIRST activity in the reservation as the
reservation start time.

Helen put me on the right track and I've got it working.

Henk van der Meer