Concepts


What is a range of values?

You can specify a comparison operator that will select records based on a range of values. For example, age is less than 33 is a query that selects records based on a range of values. It will select records with age=32, age=31, etc.

A range of values is a set of values specified by one comparison operator.

Note that ranges also work with character data. For example, if you had a database of students and you wanted to split the names roughly in half based on alphabetical order, you could use the query <"m". This would select all records with a field value that began with a character before m in the alphabet.


Copyright 1997 by the Curators of the University of Missouri