Microsoft Access Database Development With VBA

SQL Operators: <>

   

Introduction

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-2013 FunctionX, Inc. Home