Maybe this works:
select cast(field as integer), * from table order by 1

On Thu, 21 Apr 2005 11:22:58 +0200, Tim Gahnström wrote:

>
>-----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
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>