title: Add a Column that Represents a Concatenation of Two Other Varchar Columns
body: <p>I have an employees table and I want to add a third column valued as the concatenation of the first and last name called "FullName". How can I accomplish that without losing any data from either of the first two columns?</p>