Date sql question

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
LVL 1
AleksAsked:
Who is Participating?
 
John_VidmarCommented:
select	*
from	table
where	(	PPIssuedate IS NULL
	OR	PPIssuedate BETWEEN '01/01/1900' AND '01/01/2070'
	)

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.