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