SQL - Sorting with Alpha - numeric character

Hi All Experts,

How to sort the field which contains alphanumeric character.
Suppose my the field data as below.

1,10,1a,2a,200a,a20,3,5

I want my output is 1,1a,10,2a,200a,3,5,a20

Is that possible to achieve?

Thanks in advance :-)

It's possible, but you'd have to break the value into its alpha and numeric parts in your SQL code and then sort on both. If possible, a better option might be to store the alpha and numeric portions in separate columns. You can then simply sort on those two columns.