Thanks,
I forgot about it.
----- Original Message -----
From: Nick Slay <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 12, 2000 10:54 AM
Subject: Re: Urgent
> 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.
>
>
------------------------------------------------------------------------------
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.