You can not order by the calculated column. Add it as a field into your statement and order by this column.

>If I remove the ORDER BY clause, it works. Any ideas?
>
>>This is a SQL statement that is created in code. I'm getting this error:
>>

>>SQL: Column ' ' is not found.
>>

>>This is the SQL:
>>

>>SELECT ;
>>SEQ_NUM AS Fld1, ;
>>DOC_CODE AS Fld2, ;
>>DAY_WEEK AS Fld3, ;
>>OFF_CODE AS Fld4, ;
>>FROM_TIME AS Fld5, ;
>>TO_TIME AS Fld6, ;
>>MARK_LEVEL AS Fld7,  ;
>>[ ]AS Fld8 ;
>>FROM SCHDOC2 ;
>>ORDER BY RIGHT("  "+doc_code,2)+RIGHT("000"+seq_num,3) ;
>>INTO CURSOR ReportCursor
>>