I have appended one table to another, and now they are not sorted alphabetically. Is there any way to resort the table so that it is in alphabetical order?


You can do this using an SQL Select and then saving the query result as a new table. It should look something like this:

enter image description here

The sort will default to ascending order, if you want it descending add "Desc" after the column name in the 'Order By...' field.

  • Great, can you please mark it as the accepted answer so that others can benefit if they have a similar question. – T_Bacon Sep 30 '16 at 11:13
  • Please also note that by default a table is not sorted. It might appear so but the sort order is not guaranteed. You can sort you table using the SQL Select shown above or you can sort the table when it's viewed in a browser in MapInfo Pro using the Sort option on the individual columns. – Peter Horsbøll Møller Sep 30 '16 at 11:45
  • At the top left of my answer there should be a button to mark as answer (below the up and down voting buttons). – T_Bacon Sep 30 '16 at 11:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.