>And a short version of option 1, ergo 1b:
>
index on TRANSFORM(CheckStub, "Y") + VendCode
>
>
>The nice thing about all these is that the false values will come before true values. I wish we had that order in language, when naming code: post_hook comes before pre_hook; "before_*" comes after "after_*"... whichever word pair I tried, it sorts wrongly.
>
>Hmmm... maybe ante- and post- would be good?
Then you probably already know in which book the start comes after the end?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)