This discussion is archived
1 Reply Latest reply: Oct 25, 2012 5:50 AM by grir28 RSS

Sorting by numerical order using alphanumerical values from a table column

518276 Newbie
Currently Being Moderated
I am using Oracle database
I have the values as 001, 2, 102-X, 1010-1012, B103, West store, Basement , '1009,1020'
I need to order as 001, 2, 102-X, B103, '1009,1020', 1010-1012, Basement, West Store

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points