precedence for like and between??

[martin]

I have a like and a between in a query. The like is for
sex and the between is for dates. The likes can be m,f,*.
however when i do a like m and a between it gives both m
and f. The Between has a is null before it. Why is it
picking up f's?

Thanks
Martin

 

[Duane Hookom]

Share the SQL view of your query.