name

[jt01]

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.

 

[Allen Browne]

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.

 

[KARL DEWEY]

You also might want a field for name suffix - JR, SR, II, and another for
title - Mr., MS, Miss, Dr., etc.