I have a list of given names that include first names and the middle names. I want to remove all of the middle names leaving only the first name.
Here is an example of the names I have in the list. I have bolded the part of the name that I want to keep. The query should only select an remove the non-bolded names. As you can see some people have a middle name and others have none. Some first names are hyphenated and some middle names have 2 words.
Anna Oi Chan
My first query worked on most names, except for instances where a persons first name had a hyphen in it (i.e. Peta-Louise Mary).