Subject Re: SQL Syntex
Author Dorin Vasilescu

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

--- In, "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