title: Handling null values from ResultSet
body: <p>I used the following codes to retrieve values from a database:</p>
  
  <pre><code>if( !rs.bof ){
       rs.MoveFirst();
       while ( !rs.eof ){
          output.innerHTML += rs.fields( "Name" ) + ","
          output.innerHTML += rs.fields( "Address" ) + "&lt;br&gt;"
          rs.MoveNext();
      }
  }
  </code></pre>
  
  <p>But if the Address is null then it writes:</p>
  
  <pre><code>Sherlock Holmes, 221B Baker Street
  James Moriarty, null
  </code></pre>
  
  <p>I've tried using:</p>
  
  <pre><code>if( rs.fields( "Address" ) != null &amp;&amp; rs.fields( "Address" ) != "" )
  </code></pre>
  
  <p>What should I do to make the null values appear as an empty string?</p>