8 Replies Latest reply on Dec 4, 2007 7:30 PM by Newsgroup_User

    Need Help Sorting Alphanumeric list - with 1 coming before 10

    Photoshare Level 1
      I am querying a table of categories and while the category field is a text field some of the data begins with numbers. What I have never been able to figure out how to do is sort categories so that smaller numbers appear before larger ones. See example:
      4 Megapixel
      5 Megapixel
      6 Megapixel
      10 Megapixel
      11 Megapixel
      21 Megapixel
      etc.

      When I sort this list using listsort the list appears as follows:

      10 Megapixel
      12 Megapixel
      21 Megapixel
      4 Megapixel
      5 Megapixel
      6 Megapixel

      i was wondering (hoping) that someone here would know how I can sort these items so that they appear like in first list.

      Thank you.