title: IsNull() sql function
body: <p>I am attempting increment the value of a column field named "Number" by 1, and if the value is currently Null I would like to set the value to 1 because a Null value cannot be incremented. I discovered the isNull() function and do not get the results using the following statement:</p>
  
  <pre><code>Update SomeTable set Number = IsNull(Number, Number+ 1) where
  ItemCode = '000000' ;
  </code></pre>
  
  <p>My question is basically how to simultaneously update a field value by the increment of 1 and set the value to 1 if it is currently "NULL"</p>
  
  <p>Thanks!</p>