Sqlite query - order results with last numbers

Question

I would like to execute a SQLite query and order my results with the latest numbers.

For instance:

SQLite will usually order such results when I specify ASC in the text box:

0, 1, 2, A, B, C

While I would like to:

A, B, C, 0, 1, 2

Any ideas? Is it possible?

Thank!

Nick.

Answer 1

I don't know anything about sqllite, but something like this should work (assuming, of course, that there is some function isnumeric): -

order by isnumeric(colA), colA

to display your numerical values ​​first.