DropDown In Alphabatized Order

[LinuxGuy]

i need to make my Dropdown Show up in Alphabetical Order
when its displayed can someone help me ?? here is my Code
I use to display my Dropdown List...

<select type=&quot;text&quot; name=&quot;x_Customer&quot; value=&quot;X_Customer&quot;>
<%

strSQL2 = &quot;SELECT Company from Contacts&quot;
Dim rs
Set rs = Server.CreateObject(&quot;ADODB.Recordset&quot
rs.Open strSQL2, conn, 3

If Not rs.EOF Then
Do Until rs.EOF %>
<option value=&quot;<%=rs(&quot;Company&quot%>&quot;><%=rs(&quot;Company&quot%></option>
<% rs.MoveNext
Loop
End If
rs.Close
%>
</select>

 

[shaddow]

Use
strSQL2 = &quot;SELECT Company from Contacts order by Company&quot;
equivalent to
strSQL2 = &quot;SELECT Company from Contacts order by Company ASC&quot;

or

strSQL2 = &quot;SELECT Company from Contacts order by Company DESC&quot;

________
George, M

 

[LinuxGuy]

thanks im pretty new to SQL statments, thanks for helping