Hi

Try
select * from table order by cast(field as integer)

--- In firebird-support@yahoogroups.com, "Lakshathipathi"
<arul_s2003@y...> wrote:

>
>
> Hi all,
>
> I am new to Firebird. I am converting the existing application which
> uses ODBC (IBM DB2 UDB). In many cases Firebird throws an error
>
> "select * from table order by int(field)" in this statement "int"
> gives a problem. I feel int, substr, etc.. should be available in all
> SQL.
>
> Can you give equivalent for int? and also some documents to go through
> the data types used in Firebird.
>
> with thanks,
>
> Arul