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.

Reply via email to