> You also have to be careful if the ORDER BY column has a numerical
> reference to a column derived from a sub-select with an input
> parameter in it. The input parameter is actually duplicated in the
> list of params.

Hi Jason,

I just set up some tests to try and confirm the various permutations.

Thought you may like to know that the above ORDER BY issue does not
happen (FB1.0) if the statement is a UNION - I've yet to try other
variations like GROUP and HAVING.

--
Geoff Worboys
Telesis Computing