[thelist] Sorting with SQL

Rob Smith rob.smith at THERMON.com
Tue Sep 23 13:38:12 CDT 2003


Hi list,

I've got a huge database and I need to display products in ascending order.
What I need is:

  ABC 1-2
  ABC 3-6
  ABC 4-5
  ABC 10-3

However when I sort by ascending order I get

  ABC 10-3
  ABC 1-2
  ABC 3-6
  ABC 4-5

Is there a trick I can do to sort these (about 30) records in the "correct"
order.

Rob Smith


More information about the thelist mailing list