Here is how to order by ASC or DESC in sql. Use ASC for ascending and DESC for Descending. Set objGetSort1ENTCensus = cnnConn.Execute("SELECT * FROM qxSQLCensusBasicView ORDER BY occupancy DESC") SHARETHIS.addEntry({ title: "ORDER command in SQL using ASP", url: "http://code.netexceed.com/asp/order-command-in-sql-using-asp/"...