>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 >Looks like you're missing a space after ], e.g. [ ] as fld8 or cast("" as C(1)) as fld8