<div>
I didn't want this in CF...I am doing this in SAS SQL. &nbsp;The case end in the where statement didn't work. &nbsp;It doesn't like the less than sign...the query gives an error in the log.
</div>


<div>
I've requested that this question be closed as follows:<br />
<br />
Accepted answer: 0 points for leerljr68's comment <a href="https://www.experts-exchange.com/questions/28378662/SQL-query-and-if-statement.html?anchorAnswerId=39901107#a39901107" rel="ugc">#a39901107</a><br />
<br />
for the following reason:<br />
<br />
Accepting own comment since I figured it out myself with no assistance from the other expert comments. &nbsp;Thank you.
</div>


<div>
I'm awarding points to those who responded.
</div>


<div>
Even though I answered my own question, I'm awarding points for taking the time to respond. &nbsp;Thank you all.
</div>


<div>
<div class="content wysiwyg-content">
In my where statement I need to check two areas, if the first isn't populated, check the other.<br />
<br />
if a.C_EFF_DT is NOT NULL then a.C_EFF_DT &lt;&nbsp;date(current date - 6 months)<br />
if a.C_EFF_DT is NULL then b.C_EFF_DT &lt;&nbsp;date(current date - 6 months)<br />
<br />
So basically if the first C_EFF_DT is null then check the second C_EFF_DT, if it has a date, then check it and don't worry about the second date.
</div>
</div>


In my where statement I need to check two areas, if the first isn't populated, check the other.

if a.C_EFF_DT is NOT NULL then a.C_EFF_DT < date(current date - 6 months)
if a.C_EFF_DT is NULL then b.C_EFF_DT < date(current date - 6 months)

So basically if the first C_EFF_DT is null then check the second C_EFF_DT, if it has a date, then check it and don't worry about the second date.

SQL query and if statement

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.