name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Im designing a table not sure which is the best way to store an individual's
name in a table. is it best to have three separate field for each, such first
name, last name and middle name.
 
Yes.

Using atomic fields (a separate field for each piece of information) is the
right approach. You reap the benefit when you need to match on just
FirstName or LastName.
 
You also might want a field for name suffix - JR, SR, II, and another for
title - Mr., MS, Miss, Dr., etc.
 
Back
Top