Hi friends
i've following query which returns all records ignoring WHERE clause

SELECT it.pkey,it.code,it.usercode ;
FROM it ;
WHERE EMPTY(it.status) AND ;
(INLIST(ALLTRIM(UPPER(it.code)),'PT01','PT02','PT03','PT04') OR ;
INLIST(ALLTRIM(UPPER(it.usercode)),'PT01','PT02','PT03','PT04')) ;
INTO CURSOR cPts NOFILTER 

where as following returns only records i want ! what am i doing wrong above

select it
BROWSE FOR EMPTY(it.status) AND (INLIST(ALLTRIM(UPPER(code)),'PT01','PT02','PT03','PT04') OR INLIST(ALLTRIM(UPPER(usercode)),'PT01','PT02','PT03','PT04'))

Thanks for ur advise.