order by problem

You could do something similar to this:

select quality, owner, name

from imageTBL

where len(name) = 9

order by name

union

select quality, owner, name

from imageTBL

where len(name) = 10

order by name

Mind you, I am making the assumption that the database engine will respect the order of the 2 result sets. Some might, others might not.

G'day

When asking a DB question, it helps answer it if you tell us what DB you're using.

You're gonna need to somehow create a column that has only the numeric part of that string, and order by that.

This'll involve using whatever string functions your DB offers to to a find / substr or a regex substitution.  The reason I am vague here is because this is where it's important for you to identify which DB you're using before people will be able to answer your questions thoroughly.

I suspect this will not be a very performant operation, so rearranging your table structure to store that value when the row is inserted / updating might be a better approach, if performance is a concern.

--

Adam