Subject Re: [firebird-support] ORDER BY 'alias'
Author Helen Borrie
At 09:09 AM 15/09/2004 +0100, you wrote:

>I've just been stung again by some port problems which rely on ORDER BY
>'alias'. Can't see anything in the roadmap, is this anywhere on in the
>pipeline, or am I stuck with having to re-engineer the SQL for it via
>ADOdb ?

Can you not work with
order by <degree-number>?

The other option is
order by <repeat-the-expression>