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

Is this from VFP native or from VFPOleDB? The reason I ask is that the only time I got this type of message was from the VFPOleDB which is causing some weird errors under IIS. As for that situation, I see that are no space after []. Could it be a factor?