>Thanks, I got it....
>Jim
>
>>>What I want to do is select records from a table based on the qqfield. The qqfield values for each record are different and are based on other variables in my program...
>>
>>In that case, perhaps you can use the evaluate() function:
>>
>>

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

I think the last line:

  and IIF(!EMPTY(promolist.qqfield), eval(Promolist.qqfield), .T.)

can also be simplified:

  and (EMPTY(promolist.qqfield) or eval(Promolist.qqfield))

Although some discussion may arise as to whether the second version is really simpler. It uses less characters, but an important question is: which version is easier to understand.

Hilmar.