title: MS Access SQL replace NULL in field value
body: <p>I would like to show the value  "NONE" if the value in a field is null OR its value if
  the field is not null from a table using select statement.
  The statement may be similar to this:</p>
  
  <pre><code>select iif(isnull(spouse),"NONE",spouse) as spouse from biodata
  </code></pre>