How to insert firstname + lastname into fullname???
Posted on 2007-12-05
I have a table called Contacts. This table following:
Fullname. These are the core of my question.
During an INSERT statement, how do I insert the value of FirstName and Lastname into fieldname called Fullname. THis way, the values look like this:
FirstName LastName Full Name
John Doe John Doe
So, insert statement would look like this:
INSERT INTO Contacts (FirstName, LastName, Fullname) Values (ValueOfFirstName, ValueOfLastName, ValueOfFirstName and LastName combined)
Thanks in advance