title: A SQL query that replaces null values.
body: <p>I need a SQL query that returns ContactDate, SortName, City, ContactType, and Summary from the tables below. If any value is null, I need it to return the text “No Entry”.</p>
  
  <p><strong>ContactTable</strong></p>
  
  <ul>
  <li><em>ContactID</em></li>
  <li>ContactDate </li>
  <li>UserID </li>
  <li>Summary </li>
  <li>ContactType</li>
  <li>SortName</li>
  </ul>
  
  <p><strong>UserTable</strong></p>
  
  <ul>
  <li><em>UserID</em></li>
  <li>FirstName</li>
  <li>LastName </li>
  <li>AddressID</li>
  </ul>
  
  <p><strong>AddressTable</strong></p>
  
  <ul>
  <li><em>AddressID</em></li>
  <li>City</li>
  <li>Street </li>
  <li>State</li>
  <li>Zip</li>
  </ul>