Add the ORDER BY to the end of the query... ie,
SELECT FirstName, LastName
FROM Client
ORDER BY LastName, FirstName
You can also put DESC to order descending, ie, ORDER BY LastName DESC
> From: "Pavan" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Wed, 12 Jul 2000 11:00:27 +1000
> To: <[EMAIL PROTECTED]>
> Subject: Urgent
>
>
> Hai,
> can i get information how to display alphabetical order from a query
>
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
> body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
