ORDER BY

The ORDER BY Clause puts your recordset in a specific order
SELECT * FROM People ORDER BY LName

The SQL Statement above will retrieve

ALL fields: SELECT *

From the table named People: FROM People

With LName in alphabetical order: ORDER BY LName

If this is the original table
People
FNameLNameCategory
JohnSmith1
AlJones2
FredAdkins2


Your recordset returned would be this:
People
FNameLNameCategory
FredAdkins2
AlJones2
JohnSmith1



Come learn HTML or Classic ASP in Honolulu, Hawaii!

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