Hi, I'm not sure what DBMS you are using but most can sort many ways. You may want to read your DBMS manuals and look for a natural sort method. MySQL uses something like ORDER BY <column_name> NATURAL ASC or ORDER BY <column_name> NATURAL DESC. Somewhere on the net should be an old thread about sorting mixed numbers and alpha characters in MySQL. Try Googling the topic. If the DB can handle the sort for you, you'll save time and network traffic. Unless you really need to be able to sort this on the client side.
Hope this helps Randy On Tue, Feb 2, 2010 at 8:37 AM, HenryRock <henryloke.myetr...@gmail.com> wrote: > I facing a problem in sorting : > > 1A,2A,3A,... 10A, 11A, 12A, 13A, 14A > > Sample data. > > I using the SQL to sort ASC but it return result as below: > > 12A > 13A > 14A > 10A > 11A > 1A > 2A > 3A > 4A > 5A > 6A > 7A > 8A > 9A > > May I know is there have any plugin that can sort the sample data > above to 1A until 14A? > > Thanks... > -- If you ask me if it can be done. The answer is YES, it can always be done. The correct questions however are... What will it cost, and how long will it take?
