Solved

Date sql question

Posted on 2013-12-05
1
182 Views
Last Modified: 2013-12-05
I am running a query for dates, but for those records in which the date is NULL the record will not be displayed.
How can I make it display when the record is null  ?

---
 Select * from table when
   ISNULL(D.PPIssuedate, '') BETWEEN '01/01/1900'   AND     '01/01/2070'

--

When PPIssuedate is not null the results come up, but if PPIssuedate is null nothing comes up. How can I make null PPIssuedates that are NULL be displayed
0
Comment
Question by:amucinobluedot
1 Comment
 
LVL 11

Accepted Solution

by:
John_Vidmar earned 500 total points
ID: 39698785
select	*
from	table
where	(	PPIssuedate IS NULL
	OR	PPIssuedate BETWEEN '01/01/1900' AND '01/01/2070'
	)

Open in new window

0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question