Extract numeric values from Char in SQLite

Question

Hi,

I need to sort a column in database based on numeric characters in the string value.For eg one of the database column contains value a11,a12,ab01,ab02 etc.I need to sort like this ab01,ab02,a11,a12 etc,that is i need to extract only numeric values and then sort the result .Is it possible to do this using some query .I am using SQLite database.

Thanks in advance