On Wed, 9 Aug 2000, abe wrote:
> Does anyone know how to get results from a query in alphabetical order
> (for one field such as surname). I skimmed over the documentation and
> no luck.
Use the ORDER BY clause in your query:
SELECT surname, firstname FROM names ORDER BY surname;
Bret
SELECT * FROM table ORDER BY table;
that seems to do the trick for me when I need to order things alphabeticly.
Mike
- Original Message -
From: "abe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 09, 2000 10:15 AM
Subject: [GENERAL] ORDERING alphabetically
> Hi th
