Sort by last word in field

[kelvin]

Hello,

I am wondering if it is possible to write a query that will sort the results by the last word in a field.

e.g. (names are one field, I know should have been in seperate fields, inherited and there are to many files to edit)

Kevin Smith
Bob Jones
Betty Boop

Want to sort like

Betty Boop
Bob Jones
Kevin Smith

Any help or direct will be greatly appreciated.



Thanks, Kevin