Hi Steve, In the SQL order by line type "desc" after the column (eg "Order by: address desc")
Will Mitchell Mitchell Geographics, Inc. 496 Congress Street Portland, ME 04101 www.mitchellgeo.com ph 207.879.7769 fx 207.253.5756 -----Original Message----- From: Morrier, Steve [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 2:26 PM To: MapInfo List Subject: MI-L Sort by Maximum Hi All, Is there a simple way to sort a table in descending order? I'm sure there is. I have a Street file that I would like to sort by address ranges, but I would like the address ranges to start at the maximum value and go down. I have tried sticking a Max clause in the Order By row of the SQL but that doesn't work. Any ideas would be appreicated. TIA. Steve --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5782
