title: How do I update a VARCHAR column so that it contains the contents of two other VARCHAR columns, separated by a space?
body: <p>I am new to SQL, which is perhaps why I have not been able to locate a solution to the following problem.</p>
  
  <p>I have this database table where all columns are of type <code>VARCHAR(50)</code>:</p>
  
  <p><img src="https://i.stack.imgur.com/tVRy1.png" alt="f"></p>
  
  <p>And I want to update the values in <code>FullName</code> so that they are a combination of <code>FirstName</code> and <code>LastName</code>, separated by a space.</p>
  
  <p>This is what I would like to end up with:</p>
  
  <p><img src="https://i.stack.imgur.com/elU4E.png" alt="f"></p>
  
  <p>I do not want to update each row manually.</p>