Displaying names in Alphabetical Order

[kaushiks]

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

[RobDog888]

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.

[cssriraman]

Combo1.Sorted = True

[ganeshmoorthy]

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