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;
Brett W. McCoy
http://www.chapelperilous.net/~bmccoy/
-------------------------------------------------------------------------------
But soft you, the fair Ophelia:
Ope not thy ponderous and marble jaws,
But get thee to a nunnery -- go!
-- Mark "The Bard" Twain