Indeed. Thank you. Time to upgrade!




"Leyne, Sean"
<Sean@BroadViewSo An: <firebird-support@yahoogroups.com>
ftware.com> Kopie:
Thema: RE: [firebird-support] substring in "order by"-clause
21.09.2004 19:45
Bitte antworten
an
firebird-support
Telefon:

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


Sean




Yahoo! Groups Links