title: Is there a similar function to COALESCE for empty string in AS400
body: <pre><code>SELECT COALESCE(value, 'M') 
    FROM MyTable
  </code></pre>
  
  <p>In case the value is null the returned value will be set to "M"</p>
  
  <p>Is there a similar function as COALESCE in case value is an empty string?</p>
  
  <p>IBM i Version: 7.1</p>