I apologize in advance if this question has been posted and answered multiple times. I am new to this site.
My question- I have made a form with First Name, Last Name and many others I want to have both the First Name and Last Name post into their respective columns in the database but I would also like to combine the two and have it entered into a column in the DB titled FULL NAME with the format of Last Name, First Name. Is there a way to do this?
quote: I would also like to combine the two and have it entered into a column in the DB titled FULL NAME
Any specific reason? Typically it is best to avoid storing calculated values because it is easy for them to get out of synch. Just concatenate the values in sql. The concatenation operator depends on your database, but in MS SQL something like
SELECT FirstName +' '+ LastName AS FullName FROM TableName WHERE ...