-----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)"

Tim