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

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.

VB Code:

Combo1.Sorted = True

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