Subject RE: [firebird-support] substring in "order by"-clause
Author Leyne, Sean
> I'm trying to migrate a Select-Statement from DB2 to Firebird
> containing ORDER BY SUBSTR(colname, 9)
> Firebird refuses
> ORDER BY SUBSTRING(colname from 9).

What version of Firebird are you running?

I suspect v1.0, v1.5 added a feature to support using functions in ORDER
BY and GROUP BY clauses.