title: What is causing my values to be printed as #
body: <pre><code>-- Formatting purpose
  SET LINESIZE 200
  COLUMN 'Pharmaceutical Companies' FORMAT a25
  COLUMN 'Drug Count' FORMAT a10
  
  -- Code
  SELECT PHARNAME AS "Pharmaceutical Companies", COUNT (tradename) AS "Drug Count"
  FROM DRUG
  GROUP BY PHARNAME
  HAVING COUNT (TRADENAME) = (SELECT MAX ("Drug Count")
  FROM (SELECT COUNT (TRADENAME) AS "Drug Count" FROM DRUG
  GROUP BY PHARNAME));
  </code></pre>
  
  <p>Above this is my set of code to get certain values out of my database. However, the results printed are</p>
  
  <pre><code>Pharmaceutical Companies  Drug Count
  ------------------------- ----------
  Medmed Shine              ##########
  </code></pre>
  
  <p>If i remove the formatting purpose, it will show</p>
  
  <pre><code>Pharmaceutical Companies       Drug Count
  ------------------------------ ----------
  Medmed Shine                           14
  </code></pre>
  
  <p>I have tried adjusting the format size but it still displays as <code>########</code></p>