Try This

SELECT  quodtl.*, CONVERT(int, linenum) as iLineNum
FROM    quodtl
ORDER BY  iLineNum

>Hi, all
> i have a difficult problem......Can i wirte sql in crystal report to order by record?
>i know crystal reports plus-in Record Sort Expert function , but can' t use sql ....
>Because, i want to order by linenum , but this struct is char(4), i want change to integer to sort ......
>How can i do , please
>
>

>SELECT  *
>FROM      quodtl
>ORDER BY CONVERT(int, linenum)
>