Chapter 5Filtering Retrieved Records
Introduction
In this chapter, you will learn how to create conditionals via the WHERE clause. You will also learn how to use the comparison and logical operators to further refine the filtering of data within the recordsets.
Definitions
Comparison operators — Used to perform comparisons among expressions.
Expression — Any data type that returns a value.
Logical operators — Used to test for the truth of some condition.
WHERE clause — Used to filter retrieved records.
Wildcard characters — Special characters used to match parts of a value.
The WHERE Clause
Recall that a clause is a segment of an SQL statement that assists in the selection and manipulation of data. The WHERE clause is yet another ...
Get SQL for Microsoft Access, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.