Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002

    Unanswered: Sorting Columns Question

    hi all

    an Interesting question

    I have a column which stores a versin number in this format

    I want to be able to sort this text column in an ascending order. Unfortunately it gives me followed by which is not the case.

    Please let me know ASAP


  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    This is an age old question, caused mostly by the unstructured format of the version numbers.

    The simple answer is to make each of the "units" in the version number zero filled to some arbitrary width, so that your numbers would become or something like that. This makes the numbers sortable as strings.

    Another solution would be to change the storage from character to some form of binary. This would allow the version numbers to be sorted arbitrarily.

    You have to figure out what solution works best for your problem.


  3. #3
    Join Date
    Jun 2004
    you can check the next tip also
    on the comments sections is your answer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts