I need to sort alphabetically 2

[fergman]

anyone know how to make this response statment sort alhpabetically?

dim SQL
SQL = "SELECT * from employees where name "
Rs.Open SQL, schedule, 1,3

do while not rs.EOF
Response.Write &quot;<tr>&quot; & &quot;<td>&quot; & rs(&quot;name&quot & &quot;</td>&quot; & &quot;<td>&quot; & rs(&quot;monday&quot & &quot;</td>&quot; & &quot;<td>&quot; & rs(&quot;tuesday&quot & &quot;</td>&quot; & &quot;<td>&quot; & rs(&quot;wednesday&quot & &quot;</td>&quot; & &quot;<td>&quot; & rs(&quot;thursday&quot & &quot;</td>&quot; & &quot;<td>&quot; & rs(&quot;friday&quot & &quot;</td>&quot; & &quot;<td>&quot; & rs(&quot;saturday&quot & &quot;</td>&quot; & &quot;<td>&quot; & rs(&quot;sunday&quot & &quot;</td>&quot; & &quot;</tr>&quot;

 

[JohnYingling]

Have not done SQL but is there not an ORDER BY clause.

http://www.VBCompare.com

http://www.VBSortGen.com

 

[link9]

SELECT columnName FROM tableName ORDER BY columnName

check out:

http://www.devguru.com/Technologies/sqlsyntax/quickref/sql_syntax_select.html

for more info.

 

[zzfive03]

SQL =&quot;select * from employees order by name (or whatever you want to order by). You can even order by 2 items:

SQL =&quot;select * from employees order by Lname, Fname