I am just learning to use Zope with MySQL. One field in my database is an integer, goal. When I get a list of items from the database and sort on goal, the sorting is alphabetical (15 before 2 before 23 before 5). How do I get the sort order to reflect the order of the integers? In the dtml below, sqlgetleaders is the ZSQL method that returns the list of leaders (lastname, firstname, goal) from the database. <table> <tr> <td>Last Name</td> <td>First Name</td> <td>Goal</td> </tr> <dtml-in sqlgetleaders sort=goal> <TR> <TD> <dtml-var lastname></TD> <TD> <dtml-var firstname></TD> <TD> <dtml-var goal></TD> </TR> </table> Al -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Albert Kinderman California State University, Northridge albert.kinderman@csun.edu Department of Management Science