Does there exist a function that will take a Name field (text) and allow me to parse out the first characters until it encounters a space or a comma? Or is there a modification of the left, right, or mid functions that can accomplish this?
Specifically I have a LName field that in some cases has a Suffix, sometimes it is Loween, Jr. other times it is Loween III, either way, I only want the Loween.
As always… Thanks a bunch. Jenn. Happy Treating