>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?

I may be not understanding what you are asking, but putting everything in brackets may simplfy things :

(admitted during a set period) AND
(status=urgent) AND
((lead consultant=Smith) OR (lead consultant=Jones))
AND
(other filter)

Paul