I have a SQL Server table that looks like this:
1 John Dough
2 Donald Disney
3 Brajalenia Jollie-Pitt
4 A. Smith
5 James Watson
I need to take the name and split into two columns; First Name and Last Name. Sadly, I know nothing about access. Can anyone help me with such a query?
PS - My columns have no Middle Initials and/or suf/prefixes