Subject Re: substring in "order by"-clause
Author performasoftware
Hi

> Firebird refuses
> ORDER BY SUBSTRING(colname from 9).
>

Use 'SELECT SUBSTRING(colname from 9) ... ORDER BY 1', where
1 is the colnum.

Dominik