I'm trying to separate the last name from the first name in a field. I can
get the first name by using the "left" function. Does anyone know how to get
the last name? I tried using "right" function but on some it gives me the
whole last name plus part of the first name, others it gives me some of the
letters of the last name. Please advise - thanks!