... in this? Or dont I need any?<BR><BR>SELECT * FROM Jobs WHERE JobTitle LIKE '%manager%' OR Description LIKE '%manager%' AND CloseDate > GetDate()-1 ORDER BY SalaryRange ASC
depends on what you want, we can't answer this for you. How do you want to have the criteria evaluated?
.. all records that contain the word 'Manager' in either of the two named field and also meet the rest of the criteria.<BR><BR>Thanks
WHERE (field like '%manager' or otherfield like '%manager%') AND (other criteria)