>Hi all,
> i use vb.net dataset and visual foxpro to database. I want to use sql to order by convert int.
>If use sql server i can SELECT * FROM apos ORDER BY CONVERT(int, scode).
>if visual FoxPro i also can SELECT Cast(sCode as int) as s, bcode, bcode2, descript, unit, cdescript, uprice FROM apos order by s
>
>But in vb.net dataset selectCommand i use SELECT Cast(sCode as int) as s, bcode, bcode2, descript, unit, cdescript, uprice FROM apos order by s, it will error say Error in list of function arguments: 'AS' not recognized. Unable to parse query text.
>
>How can i do? Thank you ~~~

Similar syntax to the above works for me using VFPOLEDB. Are you sure you do not have a typo in the code?