title: How to replace 0 with N/A
body: <p>In my case statement, I'm using <code>0</code> if the value is <code>NULL</code>. Now I want to replace <code>0</code> with <code>N/A</code>. I've tried using <code>ISNULL</code> and <code>COALESCE</code> but its not working.</p>
  
  <p>Below is my code.</p>
  
  <pre><code>SELECT BOM.STYLE_ID, BOM.SEASON_ID,
         SUM(CASE WHEN BOM.Ad_compo_desc LIKE UPPER('%emb%') THEN 1 ELSE 
             ISNULL(0, 'N/A') END) AS EMBRO,
         SUM(CASE WHEN BOM.Ad_compo_desc LIKE UPPER('%print%') THEN 1 ELSE 
             ISNULL(0, 'N/A') END) AS PRINTING
  FROM IPLEXSTY_AD_BOM_DTL BOM
  WHERE CONTENT_CLASS = 'ART'
  GROUP BY BOM.STYLE_ID, BOM.SEASON_ID;
  </code></pre>