mardi 12 janvier 2016

SQLite sort varchar that contains letter and number

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