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 NOFILTERwhere as following returns only records i want ! what am i doing wrong above