Jim,

I'm wondering if there are some design issues with what you are doing, but the eval() function is helpful for this. Of course, qqfield must be in the form of table1.field1 for this to work.

select * from promolist;
    where qq_promo and BITTEST(region,0);
    and DATE() <= promolist.expire;
    and iif(!empty(qqfield),eval(qqfield),.f.)

>Steve,
>
> Yes that is correct except they are not memory variables, they are fields in another table.
>
>Jim
>
>>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.)
>>>