title: Coalesce Function in DB2
body: <p>I am using IBM DB2. I have a query which gives the output as:</p>
  
  <h2>NAME         /               AMOUNT</h2>
  
  <p>CST  /                    -</p>
  
  <p>VAT  / 1400</p>
  
  <p>ST   /  -</p>
  
  <p>I am trying to write a coalesce function for AMOUNT. The datatype of AMOUNT is decimal(10,2)</p>
  
  <pre><code>COALESCE(AMOUNT,'&amp;nbsp')
  </code></pre>
  
  <p>The purpose of me doing is, I want a space if the AMOUNT is null, but all I get is an error like "incompatible argument".</p>
  
  <p>How can I achieve a space? Please help!</p>