I have the following table, say, MyDRAW

Code:
DRAWNO   PRIZENO
A123/14  8458
I managed to use SUBSTRING function to spli the PRIZENO into 4 character, 8 4 5 8

Code:
SUBSTRING(PRIZENO, 1, 1) AS FIRSTNo,
SUBSTRING(PRIZENO, 2, 1) AS SECONDNo,
SUBSTRING(PRIZENO, 3, 1) AS THIRDNo,
SUBSTRING(PRIZENO, 2, 1) AS FOURTHNo,
But, My Question is how to sort this number into their order ASC, for example: 4 5 8 8

Therefore, after the sorting, my Select result can be as follows:
Code:
DRAWNO  PRIZENO FIRSTNo SECONDNo THIRDNo FOURTHNO SORTED1 SORTED2 SORTED3 SORTED4
A123/14 8458    8       4        5       8        4       5       8       8
Thanks.