Back to the Tips page
Back to Tracy

Examples of custom SQL strings

With a little practice, you can get the Find routine to do just about anything you want it to.

There are a few things to remember:

Samples:

To find everything from a county collected in a particular month--say May in Brazos County, Texas:

To find everything from a county collected over a range of dates from a particular county by a particular collector:

The Boolean not can be used to exclude certain results and or can be used to combine two searches.

For example, to make the previous search, but exclude collections by Monique Dubrule Reed:

To find everything collected in Brazos County in 1992-1994 by Monique Dubrule Reed (or Monique Dubrule or any combination of Monique and her chums), as well as those specimens by that collector from Leon County, regardless of date:

Other searches can be constructed in exactly the same way.

Back to the Tips page
Back to Tracy