Order by alpha before numeric

Hello, given the following product titles how can you order by alpha characters before numeric characters?

For example:

10 Answers For Atheists
10 Answers For Skeptics
100 Answers To Questions About Loving Yr Husband
100 Answers To Questions About Loving Yr Wife
4000 Questions & Answers On The Bible
500 Questions & Answers From The Bible
Absolute Answers To Prodigal Problems
Answers
Answers Book For Kids V1
Answers Book For Kids V2
Answers Book For Kids V3
Answers Book For Kids V4
Answers For The 4-A Epidemic
Answers To Evolution Pamphlet (Single)
Answers To Prayer (May)

Desired:

Answers
Absolute Answers To Prodigal Problems
Answers Book For Kids V1
Answers Book For Kids V2
Answers Book For Kids V3
Answers Book For Kids V4
Answers For The 4-A Epidemic
Answers To Evolution Pamphlet (Single)
Answers To Prayer (May)
10 Answers For Atheists
10 Answers For Skeptics
100 Answers To Questions About Loving Yr Husband
100 Answers To Questions About Loving Yr Wife
4000 Questions & Answers On The Bible
500 Questions & Answers From The Bible
gogetsomeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

KwoofCommented:
create a computed column to do the sort...

start with the original name of the title
if the ascii value of the first character is >= 65 (capital A), then leave the name as is to the computed column
otherwise until the ascii value is 32 (space), add 75 and replace the character (to move 0 to be one value higher than 'z')
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PortletPaulfreelancerCommented:
this meets the expected results above:
SELECT
       title
FROM books
ORDER BY
          CASE WHEN title LIKE '[0-9]%' THEN 1 ELSE 0 END
        , title
;

Open in new window

0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.