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

No, just straight VFP in a PRG right now for testing.