title: Using COALESCE and Converting datetime fields
body: <p>I was given some code from a current user that I can't figure out how to convert to Microsoft SQL Server 2014.</p>
  
  <pre><code>,TO_CHAR( COALESCE( TASK.ACT_START_DATE, TASK.TARGET_START_DATE,
  TASK.EARLY_START_DATE ), 'MM/DD/YYYY HH24:MI') 
      ||
  COALESCE( NVL2( TASK.ACT_START_DATE, ' A', NULL), 
  NVL2`enter code here`( TASK.TARGET_START_DATE, ' P', NULL), 
  NVL2( TASK.EARLY_START_DATE, ' E', NULL))  AS START_DATE_FMT
  </code></pre>
  
  <p>The date fields have to be converted in order to add either an "A", "P" or an "E" behind the date. </p>
  
  <p>Is there a way to use a similar code in SQL Server to get the information? I've considered using a CASE statement to validate for Null but can't get the syntax correct.</p>