A good example why it is better not to store composite info in table. When you have separate columns for fore- and last names, you always can easily calculate full name, and you don't need to have complex formulas whenever you need some part on this full name instead.
In added file are formulas for case when name parts are on separate columns, and also when full name is used instead.
|