Link to home
Start Free TrialLog in
Avatar of Aleks
AleksFlag for United States of America

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of John_Vidmar
John_Vidmar
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial