title: How set 0 with MAX function when it is NULL?
body: <p>I would like to understand how to set 0 value of the attribute when it is NULL with MAX function. For example:</p>
  
  <pre><code>Name columns:
  number - date
  
  Values:
  10 - 2012-04-04
  11 - 2012-04-04
  12 - 2012-04-04
  13 - 2012-04-15
  14 - 2012-06-21
   1 - 2013-07-04
  </code></pre>
  
  <p>Number is incremental field, but it has set itself 1 when new year has come.
  But result of: </p>
  
  <pre><code>SELECT (MAX(number)+1) number WHERE date LIKE "2014%" 
  </code></pre>
  
  <p>is NULL and not 1 because MAX(number) is NULL and not 0 </p>