Remove numbers from field in ORDER BY

[improvcornartist]

I have a table (books) with 2 columns (book_id, book).
The table looks like:
[HTML]19 Psalms
20 Proverbs
60 1 Peter
61 2 Peter[/HTML]
I want to sort this by text first, then number if a book has a number. So the sorted data would look like:
[HTML]60 1 Peter
61 2 Peter
20 Proverbs
19 Psalms[/HTML]
My query is

SELECT book
FROM books
ORDER BY trim(replace(replace(replace(book,'3',''),'2',''),'1','')), book

This works, but isn't there a better way?

[improvcornartist]

My problem with this query is that replace is a VBA function, so it doesn't work when I try the query outside Access. Is there another way to do this?

[missinglinq]

"My problem with this query is that replace is a VBA function, so it doesn't work when I try the query outside Access. Is there another way to do this??"

Where exactly are you trying the query "outside of Access?"

Linq ;0)>

[improvcornartist]

Sorry I didn't specify. I'm trying to use VBScript. Even within Access, I would like to find any better way to sort the data.