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