Aleks
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.