| Subject | RE: [firebird-support] substring in "order by"-clause |
|---|---|
| Author | Leyne, Sean |
| Post date | 2004-09-21T17:45:17Z |
> I'm trying to migrate a Select-Statement from DB2 to FirebirdWhat version of Firebird are you running?
> containing ORDER BY SUBSTR(colname, 9)
>
> Firebird refuses
> ORDER BY SUBSTRING(colname from 9).
I suspect v1.0, v1.5 added a feature to support using functions in ORDER
BY and GROUP BY clauses.
Sean