4 ms·
What you need is to separate components of a name that can be used separately. If your app wants to say "Welcome John" in some places and "How can I help you M
by webjprgm 14y ago
What you need is to separate components of a name that can be used separately. If your app wants to say "Welcome John" in some places and "How can I help you Mr. Smith" in others, you need to have FirstName and LastName fields. If you also want to say "Account details for John A. Smith" then you need another FullName field.
You can't have just FullName, because parsing the name for it's components is incredibly complicated. (E.g. some people have last names with spaces in them.)
A suggestion below says FullName and PreferredName, which would probably work for many applications.