sql expression "AND"+"OR"

[fintan]

Hi I'm doing a search and results page. I need to filter the page by "Section" and/or "Name". I was wondering how you would phrase it.
Thanks
fintan.

[lorax]

Could you be a bit more specific?

[andreasfriedrich]

... WHERE section='whatever' AND name='whoever'

... WHERE section='whatever' OR name='whoever'

[fintan]

Solved it, I put in wildcards and made variables for them.
But thanks for answering.

SELECT newdateclosed, callID, datelogged, user, Section, description, Name, staff_number FROM closedcalls WHERE Section LIKE 'MMColParam' AND staff_number LIKE 'varstaff_number' AND (datelogged BETWEEN format(#vardatelogged#, 'mm/dd/yyyy') AND format(#varnewdateclosed#, 'mm/dd/yyyy')) ORDER BY callID DESC

vardatelogged = %
varnewdateclosed = %