I have a table with a Customer_Name field that holds data like:
Dr. John L. Jones
Dr. James Doe
Dr. Jane Dee Long
I need to sort this data by last name, first name. some rows have a middle name, some have middle initial, and some have no middle at all. All have the Dr. at the beginning.
Any ideas how to do this using SQL?