title: How to Substitute a String if record is NULL in T-SQL
body: <p>I'm writing a T-SQL report that shows the number of accounts that are in different statuses for different customers. The report results in something like:</p>
  
  <pre><code>Customer1    NoService        7
  Customer1    IncompleteOrder  13
  Customer1    NULL             9
  Customer2    NoService        12
  Customer2    Available        19
  Customer2    NULL             3
  ...
  </code></pre>
  
  <p>The 'NULL' status is valid data, but instead of displaying NULL, I want to display "Pending". Here is my SQL so far:</p>
  
  <pre><code>USE cdwCSP;
  SELECT
     sr.sales_region_name   AS SalesRegion
     , micv.value
     , COUNT(sr.sales_region_name)
  FROM prospect p
     LEFT JOIN sales_region sr
       ON p.salesRegionId = sr.sales_region_number
     LEFT JOIN prospectOrder po
       ON po.prospectId = p.prospectId
     LEFT JOIN wo
       ON wo.prospectId = p.prospectId
     LEFT JOIN woTray wot
       ON wot.woId = wo.woId
     LEFT JOIN miscInformationCustomerCategory micc
       ON micc.prospectId = p.prospectId
     LEFT JOIN miscInformationCustomerValues micv
       ON micv.miscInformationCustomerCategoryId = micc.miscInformationCustomerCategoryId
     LEFT JOIN miscInformationCategory mic
       ON micc.miscInformationCategoryId = mic.miscInformationCategoryId
  WHERE wot.dateOut IS NULL
       AND mic.categoryName LIKE '%Serviceability%'
  GROUP BY sr.sales_region_name, micv.value
  ORDER BY sr.sales_region_name, micv.value;
  </code></pre>
  
  <p>Any help would be appreciated, I'm still learning T-SQL so this might be an easy question to answer.</p>