I have records like
A5 A4 Z1 B2 C7 C1A C11A B1 B4
I want them to be sorted in this manner
A4 A5 B1 B2 B4 C1 C11A C7 Z1
ORDER BY clause.
I want them to be sorted by alphabets and then by numeric values.
For your request:
As @Johnny000 commented, you can find more in this related answer on SO.