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)
>