Search our sample db by first or last name. (% returns all)

[Try 'am' or 'er' for an example]

I'm always getting requests for a sample of how to search a DB for certain records. It's really no different then doing any other query except that you need to use wildcards.

In ASP / ADO the wildcard character is %. It works the way most of us have come to expect * to work. Why is it %? I have no idea, but it is.

An Access 97 version of the database is available for download here.