I need a function to use in a query which would be similar to the Mid function (but Mid won't work here). Instead of telling the function how many characters to count, I need it to simply find the first instance of a blank space " " and then I intend to order query output by the next character, like this:
ORDER BY Function(FirstName Last Name)
The goal is to be able to order by last name for a table that has only first name/last name combinations in one field instead of two.