Structured Query Language (SQL) Tutorials

WHERE

SELECT * FROM People WHERE LName='Smith'

The SQL Statement above will retrieve

ALL fields: SELECT *

From the table named People: FROM People

With the requirement that the LName is Smith: WHERE LName='Smith'

If this is the original table

People
FName	LName	Category
John	Smith	1
Al	Jones	2

Your recordset returned would be this:

People
FName	LName	Category
John	Smith	1

Come learn HTML or Classic ASP in Honolulu, Hawaii!