>>>Hi all,
>>> I want to use sql to convert int to order by like sql server
>>>

SELECT * FROM apos WHERE   (scode >='999') and (scode<='11015') ORDER BY CONVERT(int, scode)

>>>But visual foxpro can't this function , how can i do?
>>>
>>>
>>> Thank you ~~
>>

>>select * from (select *, cast(sCode as Int)  AS intsCode from ... where ...) X ORDER BY intsCode

>
>Why use a derived table when you don't need any

To be sure it works.