You need 2 periods after your macro, from the looks of things. But I'm not clear on what you are trying to do.
With the single perion, and assuming that &PROMOLIST contains "FLDA" then you will be ending up with "FLDSqqfield". In this case, assuming that "FLDSqqfield" is NOT a logical, then I can see the error you are getting.
With 2 periods it will resolve to FLDA.qqfield
good luck
>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.)
>