title: How to COALESCE two fields in the same one statement
body: <p>So, I have 2 fields, <code>Other_EEs</code>, and <code>Other_EE_Names</code> from the same table. I want to merge both into one existing field in another table without any interruption. Both contain a bit of info. So far I merged those two fields separately but the second one overrides the first one. How can I merge two fields at the same time? Here's what I'm using so far. Thanks! </p>
  
  <pre><code>UPDATE MI
     SET MI.M_Reps_Contact_Info = M.Other_EE_Names + ' '+ M.Other_EEs +
                                  COALESCE( MI.M_Reps_Contact_Info + 
                                            CHAR(13) + CHAR(10), '' )
    FROM dbo.suptbl_Sprint2_Interview AS M
   INNER JOIN dbo.suptbl_Sprint2_MgrInterview AS MI 
      ON M.Junction_ID = MI.Junction_ID`
  </code></pre>