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
>
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
