Sorting

In a database driven, profile list i would like to arrange my links by surname a-z, i have fould this peice of code:

strSQLQuery = "SELECT * FROM tablename ORDER BY Name DESC"

Which should work exept my names are in one field I.e. Name - Joe Bloggs instead of Forname- joe Surname - Bloggs, is there eny way to modify this code to sort it a-z by first letter on second word? otherwise i am going to have to rebuild my profile manager which coukd take a quite some of time

Thanks

James

p.s. i will remember to use 2 boxes for names in the future