Microsoft Access Database Development With VBA

SQL Operators: <>



The <> operator is used to find the contrary of a criterion. It is equivalent to the not equality. Here is an example that gets a list of students who are not male:

SELECT * FROM Students WHERE Gender <> "Male";

Home Copyright © 2009-2015, FunctionX, Inc. Home