Hai

Is there a way to sort a string column in ascending order with aplha first and then numeric(Dictionary order).
For example,

If the column productid has values A100,2030,B223 and 1002,
the sort order must be
A100
B223
1002
2030

Normal ascending order in SQl query gives sorting as 1002, 2030, A100 and B223.

Please help