precedence for like and between??

  • Thread starter Thread starter martin
  • Start date Start date
M

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
 
Back
Top