Subject RE: [firebird-support] SQL Syntex
Author Tim Gahnström
-----Original Message-----
>"select * from table order by int(field)" in this statement "int"
>gives a problem. I feel int, substr, etc.. should be available in all

I am very new myself and may not even understand what you are asking for but while you are waiting for a more knowledgeable response I'll do a little bit of guessing.

What you may be looking for is
>"select * from table order by cast (field as integer)"