Displaying names in Alphabetical Order
Hi,
I have few names in database. Now i have to display those names in alphabetical order in combo box. I know how to populate the combo box with the records, i just have to display them in alphabetical order.
Can u guys plz help me what should be written in a query to get the names in alphabetical order.
Regards,
Kaushik
Re: Displaying names in Alphabetical Order
In your sql query statement add the "ORDER BY Filed1 ASC" where Field1 is the field you want sorted in ascending order to the very end of your statement.
Re: Displaying names in Alphabetical Order
Re: Displaying names in Alphabetical Order
Select YourFieldList From YourTableName Order By FieldToBeSorted [ASC/DEC]
By default the sorting order is ascending, if you want decending order then specify that by adding DEC