title: Update a "main" table from an "update" table while ignoring nulls, blanks, or empty fields
body: <p>I have a main table that I am trying to update from a table that only has fields populated that need to be updated in the main table, using a unique ID to ensure I am updating only matched records. Here is what the SQL string looks like for the query:</p>
  <pre><code>UPDATE [tblMain] INNER JOIN tblUpdate ON tblMain.UUID = tblUpdate.UUID
  SET tblMain.contractName = tblUpdate.contractName
  WHERE ((tblUpdate.contractName) IS NOT NULL);
  </code></pre>
  <p>The idea is to only pull the fields from the update table that actually have data, and ignore the fields that are either NULL, blank, or empty. To be clear, I want to include ALL records in the tbleUpdate, but only update with the fields that contain data. How can I do this?</p>