O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Criteria with WHERE

You can use the WHERE clause to filter the required data. The options available are similar to those provided for Access queries with slightly different syntax. There are certain differences, especially for the specification of date and time, character strings, and placeholders, as described in the following sections.

Comparison Operators

You can use the comparison operators described in Table 9-14.

Table 9-14. Comparison Operators 
Operator Description
= Equal to
!= Not equal to
<> Not equal to
< Less than
<= Less than or equal to
!< Less than or equal to
> Greater than
>= Greater than or equal to
!> Greater than or equal to
BETWEEN expr1 AND expr2 Between expr1 and expr2
IS [NOT] NULL Is (not) equal ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required