WHERE Clause Operators Operator Description = Equality <> Nonequality != Nonequality < Less than <= Less than or equal to !< Not less than > Greater than >= Greater than or equal to !> Not greater than BETWEEN Between two specified values IS NULL Is a NULL value