Director

Gordon Hughes

<div>
Or if you wanted to select both cases where [Email] was NULL, or blank, perhaps you were looking for:<br />
<br />

<pre><code id="code-20-42844549-1">select * 
from MembersDetails
where Isnull([Email], '') = '' 
and [Renewal Date] &gt; '2019-04-02' 
and [Age] &gt; 18
order by [Membership Main]</code></pre>
<hr />
»<b><i>bp</i></b>
</div>


Or if you wanted to select both cases where [Email] was NULL, or blank, perhaps you were looking for:



select * 
from MembersDetails
where Isnull([Email], '') = '' 
and [Renewal Date] > '2019-04-02' 
and [Age] > 18
order by [Membership Main]

----------------------------------------

»bp

<div>
<div class="content wysiwyg-content">
I have the following query but is will not bring back data<br />
<br />
select * from MembersDetails<br />
where Isnull [Email] and [Renewal Date] &gt;&nbsp;'2019-04-2 00:00:00.000' and [Age] &gt;&nbsp;18<br />
order by [Membership Main]<br />
<br />
What is wrong?<br />
<br />
Gordon
</div>
</div>


I have the following query but is will not bring back data

select * from MembersDetails
where Isnull [Email] and [Renewal Date] > '2019-04-2 00:00:00.000' and [Age] > 18
order by [Membership Main]

What is wrong?

Gordon

Problem with Query

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.