This example / tutorial explains how to use the LIKE operator to perform a partial match on an Access database.

Providing search capabilities to a db enables users to query on whichever element you target them to. However allowing users to target which portion of the db they would like to query gives extra value. In this example, utilizing our db of US States (state, statename, and capital) the user can search in any of three fields (by dropdown menu input) rather than the application targeting one specific table element. Note: The db only has 50 observations in it, so it is better to search on single or double letter combinations.

Want to add value to your current search? Allow your users to search from within search results. As databases grow the necessity for the user to continually narrow a search to the item that they truly want will grow also. The following example utilizes a db on U.S. State capitals. Upon the first search two radio buttons will appear indicating a search (default) or a search within the current results. Searching within the current results will take the first search and add it to the new search and so on.

Displaying specific subsets of data from a database is easy to accomplish in .asp. The following example utilizes an Access database of Mark "The Bird" Fidrych and displays all of his season statistics for 1976 contained in the database rather than displaying the entire db.

This is an article on using Recordset. It uses GetRows method to speedup database access. One of the fastest ways of displaying database records with ASP. Sample Database and Code available for download.

This example shows how to perform a variety of statistics on your data using simple SQL such as Sum, Average, Max, Min, and Count. It uses stock trading performance of EPOS as an example.

SQL, Structured Query Language, is the most powerful tool to connect to a database regardless of the form of the database. However, building a perfect SQL statement can be very frustrating. Especially debugging -- the error message simply didn't tell you where the error is. This tutorial provides a nice summary of SQL statements.

This example shows how to get a list of all current tables in the database, get a list of dependent stored procedures for each table and do it all in a stored procedure.

The author writes "CoverYourASP's original database administration tool didn't look for foreign keys, and just displayed a confusing list of primary key values. Now, it's been improved with automatically generated list boxes." This tutorial explains how to turn those foreign keys into list boxes automatically.

Outputting data from two tables is almost as easy as displaying from one. This example utilizes two tables with state information on them. The first table (state_order) contains state abbreviations (state), state names (statename) the year each state was admitted into the union (year) and the numeric order they entered in (entered). The second table (state_capitals) contains state abbreviations (state), state names (state) and state capitals (capital). The where statement looks to make a match on the field that each table has in common to ouput the correct capital with all the info from the state_order table.