where jobs.statusid in (6) and ifnull(jobs.currworkerid,'') like '%' and jobs.dictatorid like '%' and jobs.custcode like '%' and jobs.deptcode like '%' and jobs.specialitycode like '%' and ifnull(jobs.prevworkerid,'') like '%' and jobs.jobid like '%' and jobs.supplierid like '%' and Approveddate between '2006-09-14' and '2006-09-21' or Approveddate Is Null
The where clause all works apart from the approveddate. When this runs it finds uses the criteria apart from approveddate is null and that returns every record that has a null entry in the approveddate field. It ignores that status = 6.
i need a way of having approveddate part of the whole where clause and it looks for status=6 with approveddate = null.
Any help would be gratefully recieved