这是通达信的,试试:ST:=IF(NAMELIKE('ST') OR NAMELIKE('*ST'),0,1);ZCIN:=IF(CODELIKE('300') OR CODELIKE('002'),0,1);去掉:ST AND ZCIN;