When date is Null return another value? - DB2 database
<p>I am trying to write a query which returns a specific date when the result is null.</p>

<p>My attempt:</p>

<pre><code>CASE WHEN TRIM(t1.COLUMN_NAME) is null THEN '9999-12-31'
</code></pre>

<p>I am getting the error  DB2 SQL Error: </p>

<blockquote>
  <p>SQLCODE=-199, SQLSTATE=42601, SQLERRMC=AS;END OVER CONCAT || / - + AT
  * YEAR YEARS MONTH MONTHS DAY DAYS</p>
</blockquote>

<p>Why is this?</p>