Hi Steve ---

There has to be something else wrong here because I tested your exact code with a table with char and date fields and it ran fine....are you sure that you are always spelling cField1 and cField2 correctly and they always contain valid column names?


>My SELECT statement requires 2 substitution field names and I can't get it to work with 2 substitution field names. It works with 1 substitution field name (cField1 and &cField1), but not with 2.
>
>For example:
>
>cField1 is a key field. cField2 is a date field.
>
>cField1 = cRetVa1
>cField2 = cRetVal2
>
>SELECT mytable.&cField, mytable.&cField2 FROM mytable ;
> WHERE YEAR(mytable.&cField2) = YEAR(DATE()) ;
> ORDER BY mytable.&cField ;
> INTO CURSOR rpt
>
>Thanks for your help.