>I need a select SQL statement for a medical system that select records matching something like:
>
>admitted during a set period
>status=urgent
>lead consultant=Smith OR lead consultant=Jones
>
>without the OR requirement it is easy but how can I use the OR filter when I have more than one other filter?

If the number of consultants in the list is not more than about 20 then try
WHERE... AND INLIST(lead_consultant, "Smith ", Jones ")
being careful to PADR the names to the correct number of characters