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.)