title: SQL DB2 Replace value in a column
body: <p>I have the following column, B represents boolean and the rest are empty values. I have to change all the values in this column to the word COLUMN A. </p>
  
  <pre><code>  COLUMN
    -----
  
  
     B
  </code></pre>
  
  <p>I have tried different things, for example</p>
  
  <pre><code> SELECT COLUMN 
   FROM TABLE
   WHERE COALESCE(NULLIF(COLUMN,''), 'COLUMN A');
  </code></pre>
  
  <p>And I receive the error: "Invalid character found in a character string argument of the function "BOOLEAN"." I'm kind of stuck to this question and I'm getting confused with this boolean value. I will be really happy if someone can help me, thanks!</p>