Jim,

Can you explain further? Are you saying you are storing names of memory variables in that field, and that it name of the variable may be different from record to record.

>All,
>
> I want to use macro substitution in a select statement. I have a field in a table that references variable. With the code that is below I am getting a missing operand message and I not sure why. Please help!
>
>

>select * from promolist;
>where qq_promo and BITTEST(region,0);
>and DATE() <= promolist.expire;
>and IIF(!EMPTY(promolist.qqfield) and &promolist.qqfield ,.T.,.F.)
>