Hi there,

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).

I tried some other functions (F_RIGHT,...) -> same result.

Is it generally impossible to use expressions/functions in Firebird-
Order By-Clauses or could someone suggest a solution?

Thanks in advance!