Hi! Good day
Can anyone correct my SQL Statement

SELECT EmpLastName
FROM Employee
WHERE EmpLastName <>"Espinosa" Or EmpLastName ="Lunar" Or EmpLastName ="Ramos";

I want to have a query ignore all the records with a LastName of "Espinosa, Lunar and Ramos.


Thanks in Advance.

Rylemer

SELECT EmpLastName
FROM Employee
WHERE EmpLastName <>"Espinosa" Or EmpLastName <>"Lunar" Or EmpLastName <>"Ramos";


Regards,

Beth M

Hi! Beth Still not working I Used your Query It shows all the record.

Thanks,
Rylemer

This should work:

SELECT EmpLastName
FROM Employee
WHERE ((Not (Employee.EmpLastName)="Espinosa" And Not(Employee.EmpLastName)="Lunar" And Not(Employee.EmpLastName)="Ramos"));

yeah it works thanks Beth I really appreciate your help.

Elmer :)

My pleasure. Sorry for the first hasty reply, but I'm glad we got it working.

Beth