title: What's the shortest TSQL to concatenate a person's name which may contain nulls
body: <p>3 fields: FirstName, MiddleName, LastName</p>
  
  <p>Any field can be null, but I don't want extra spaces. Format should be "First Middle Last", "First Last", "Last", etc.</p>