How to merge several attributes and Delete an attribute

Hello all,

My initial table has 3 attributes: FirstName, MiddleName and LastName. Now I 
want to merge them into one, then I could make a search action using LIKE 
more easily.
what should i do for that?

Also, I want to know how to delete one attribute from a table.

Thanks a lot,

Annie

_________________________________________________________________
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx