if i use the follow code, it will no data... Due to my data structure Scode is varchar... So i want convert to int .
But i go to visual Foxpro use the follow 2. command , it has result ?
So i don't know how can do it?
Scode
-------
0
999
11001
11015
1.
SELECT cast(sCode as int) as xx FROM apos WHERE (scode >='999') and (scode<='11015') order by xx
2.
select cast(Scode,int) from apos where scode='11001' ORDER BY s