Sorting on varchar field

From: Don (Don_at_discussions.microsoft.com)
Date: 07/22/04

  • Next message: Vishal Parkar: "Re: Sorting on varchar field" 
    Date: Thu, 22 Jul 2004 10:54:02 -0700

    I have varchar field that I want to sort using the numeric values stored in it. Here's some example of data and the sort order wanted. Is this easy to do or should I just add another column for sorting.
    P1
    P2
    P10
    P19B
    PP24
    P34

    Thanks

    Don

  • Next message: Vishal Parkar: "Re: Sorting on varchar field"