DIdn't make a difference.

>Why not use CAST('' AS CHAR(1)) instead? As in
>

>CAST('' AS CHAR(1)) as FLD8 
>

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