title: SQL how to deal with no values
body: <p>When I run the query below</p>
  
  <pre><code>SELECT 
      COUNT(COALESCE(CASE PARTPPHY.TITRE 
                        WHEN 1 THEN 'Monsieur ' 
                        WHEN 2 THEN 'Madame ' 
                        WHEN 3 THEN 'Madame ' 
                        ELSE '' 
                      END + PARTPPHY.IDENTITE, PARTPPHY.IDENTITE)) AS ident,
      RESPONSABLES.DIR_LOC,
      PARTPPHY.IU_PART_PP,
      COALESCE(CASE PARTPPHY.TITRE 
                  WHEN 1 THEN 'Monsieur ' 
                  WHEN 2 THEN 'Madame ' 
                  WHEN 3 THEN 'Madame ' 
                  ELSE ''  
               END + PARTPPHY.IDENTITE,PARTPPHY.IDENTITE) AS IDENTITE,
      FONCTIONS_ECO.LIBEL AS LIBEL_FONCTION
  FROM
      RESPONSABLES
  INNER JOIN 
      ETABLISSEMENTS ON ETABLISSEMENTS.IU_ETS = RESPONSABLES.IU_ETS
  LEFT OUTER JOIN 
      PARTPPHY ON RESPONSABLES.IU_PART_PP = PARTPPHY.IU_PART_PP
  LEFT OUTER JOIN 
      FONCTIONS_ECO ON FONCTIONS_ECO.IU_FONC_ECO = RESPONSABLES.IU_FONC
  WHERE 
      ETABLISSEMENTS.IU_ETS = 14783
      AND RESPONSABLES.GESTDEL = 1
  GROUP BY 
      RESPONSABLES.DIR_LOC,
      PARTPPHY.IU_PART_PP,
      COALESCE(CASE PARTPPHY.TITRE WHEN 1 THEN 'Monsieur ' WHEN 2 THEN 'Madame ' WHEN 3 THEN 'Madame ' ELSE '' END + PARTPPHY.IDENTITE,PARTPPHY.IDENTITE),
      FONCTIONS_ECO.LIBEL
  </code></pre>
  
  <p>This is my result</p>
  
  <p><a href="https://i.stack.imgur.com/rqjag.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rqjag.png" alt="enter image description here"></a></p>
  
  <p>Yet when I'm using this query</p>
  
  <pre><code>SELECT COUNT(COALESCE(CASE PARTPPHY.TITRE 
  WHEN 1 THEN 'Monsieur ' 
  WHEN 2 THEN 'Madame ' 
  WHEN 3 THEN 'Madame ' 
  ELSE '' END + PARTPPHY.IDENTITE,PARTPPHY.IDENTITE)) AS ident,
         RESPONSABLES.DIR_LOC,
         PARTPPHY.IU_PART_PP,
         COALESCE(CASE PARTPPHY.TITRE WHEN 1 THEN 'Monsieur ' WHEN 2 THEN 'Madame ' WHEN 3 THEN 'Madame ' ELSE '' END + PARTPPHY.IDENTITE,PARTPPHY.IDENTITE) AS IDENTITE,
         FONCTIONS_ECO.LIBEL AS LIBEL_FONCTION
  FROM RESPONSABLES
  INNER JOIN ETABLISSEMENTS ON ETABLISSEMENTS.IU_ETS = RESPONSABLES.IU_ETS
  LEFT OUTER JOIN PARTPPHY ON RESPONSABLES.IU_PART_PP = PARTPPHY.IU_PART_PP
  LEFT OUTER JOIN FONCTIONS_ECO ON FONCTIONS_ECO.IU_FONC_ECO = RESPONSABLES.IU_FONC
  WHERE ETABLISSEMENTS.IU_ETS = 1
    AND RESPONSABLES.GESTDEL = 1
  GROUP BY RESPONSABLES.DIR_LOC,
           PARTPPHY.IU_PART_PP,
           COALESCE(CASE PARTPPHY.TITRE WHEN 1 THEN 'Monsieur ' WHEN 2 THEN 'Madame ' WHEN 3 THEN 'Madame ' ELSE '' END + PARTPPHY.IDENTITE,PARTPPHY.IDENTITE),
           FONCTIONS_ECO.LIBEL
  </code></pre>
  
  <p>I have this</p>
  
  <p><a href="https://i.stack.imgur.com/QTrCV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QTrCV.png" alt="enter image description here"></a> </p>
  
  <p>My questions are the following:</p>
  
  <ul>
  <li>It does not seem to be a <code>null</code> nor an empty space: What is it?</li>
  <li>I want to have a value in my count: What should I do to have this?</li>
  </ul>
  
  <p>Thanks</p>