lname ===== person1 person2 BADGE/332 BADGE/331 person3 person4 VACANT/333 etc...when I run the following query:
SELECT Employee.e_lname, Employee.e_fname, Employee.e_mi, Employee.e_dob,; Employee.e_phq, Employee.e_unit, Employee.e_class, Employee.e_flg13,; Employee.e_flg14, Employee.e_flg15, Employee.e_flg16,; Employee.e_empstatus, Employee.e_id, Employee.e_flg2, Employee.e_pic; FROM ; employee; WHERE Employee.e_lname NOT LIKE ( "%BADGE%" ); OR Employee.e_lname NOT LIKE ( "%VACANT%" )I still keep getting all the records that are like BADGE and VACANT. How do I exclude these?