>I could see myself being pretty disappointed if I had some rather onerous
>function but knew that it would execute on less than 1% of the records
>because my first condition filtered out 99%+, only to learn that it ran on
>all records anyway.

That's about the time you break it down into multiple SELECTs. :-)