COUNT

COUNT does just that

SELECT COUNT(*) AS Numberofpeople FROM People

The SQL Statement above will retrieve

Numberofpeople which has the count of all records: SELECT COUNT(*) AS Numberofpeople

From the table named People: FROM People



If this is the original table
People
FNameLNameCategory
JohnSmith1
AlJones2
FredAdkins2


Your recordset returned would be this:
Numberofpeople
3



Come learn HTML or Classic ASP in Honolulu, Hawaii!

HOME | SQL Tutorials | XML Tutorials | OKIWEB | EMAIL ME | ASP Alliance