I have a table where I have field traffic_num(varchar) that contains this data
A100
A586
A4594
A125
A2
A492
now I want to sort that data ascending order. It would be really easy if traffic_num contains only number (without letter A), then I could cast varchar to integer CAST(traffic_num as SIGNED INTEGER) ASC. But what to do in this situation?
Aucun commentaire:
Enregistrer un commentaire