Thanks to all who responded so quickly, I knew there was a way to do it! Thanks again!
Steve -----Original Message----- From: Morrier, Steve 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
