Hi,
what I see is that you at least will get everything
where Approveddate IS NULL. You will have to add on
parentheses around (Approveddate between '2006-09-14' and '2006-09-21'
or Approveddate Is Null) as AND has precedence over OR.
Also if your query always will be against like '%' you should
molemenacer wrote:
I have a query that searches on a number of criteria and would like help on
the last line
I have included my code below:
where
jobs.statusid in (6) and
ifnull(jobs.currworkerid,'') like '%' and
jobs.dictatorid like '%' and
jobs.custcode like '%' and
Have you tried using parentheses around your last line?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: molemenacer [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 21, 2006