<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>

```
```
SELECT COALESCE(CAST(CONVERT(VARCHAR(10), ContactTable.ContactDate, 101) AS VARCHAR(10)), 'No Entry') AS ContactDate,
       COALESCE(ContactTable.SortName, 'No Entry') AS SortName,
       COALESCE(AddressTable.City, 'No Entry') AS City,
       COALESCE(ContactTable.ContactType, 'No Entry') AS ContactType
FROM ContactTable
LEFT OUTER JOIN UserTable ON ContactTable.UserID = UserTable.UserID
LEFT OUTER JOIN AddressTable ON UserTable.AddressID = AddressTable.AddressID
```
```
Here
is a chart of SQL DateTime formats for the CONVERT statement above.