how do I combine 3 columns within the same table. for
instance firstname, lastname, middlename all into one

[quoted text, click to view]

Don't combine these columns in one column, use an SQL Select query to
display the information....

Select Firstname + ' ' + Middlename + ' ' + LastName FROM YourTable

Of course if you had to, you could modify the above query into an
Update query. See BOL for examples.