SQLite Forum

Is there any way to order by "natural sort order" in sqlite?

i.e. `z2`, `z11` instead of the lexicographical `z11`, `z2`.

<https://en.wikipedia.org/wiki/Natural_sort_order>

Thanks,
Hamish