title: Case statement int to string conversion
body: <p>I'm using a db2 database.  I need a case statement that will convert every row with "-1" to "N/A".  The remainder of the rows must be formatted to a percentage.  My query is below:</p>
  
  <pre><code> SELECT
   case when sopm.TARGET_VALUE = '-1000'
          then   'N/A'
          ELSE sopm.TARGET_VALUE
          END as TARGET_VALUE
   FROM SUMMARY_PERFORMANCE_METRIC sopm
  </code></pre>
  
  <p>the data is as follows  </p>
  
  <pre><code>3.5000  
   0.8000  
   0.8500  
   0.8000  
   0.2000  
   0.0500  
   -1.0000  
   -1.0000  
   0.9500  
   0.9000  
   0.4000  
   -1.0000
  </code></pre>
  
  <p>the above script does not produce an error but does not give me the correct results either.</p>
  
  <p>desired output:</p>
  
  <pre><code>3.5
   80%
   85%
   80%
   20%
   5%
   N/A
   N/A
   95%
   90%
   40%
   N/A
  </code></pre>