>> str(checkStub) + vendCode
>>
>>but that gives me "invalid type".>* Option 1 >index on transform(CheckStub) + VendCode > >* Option 2 - smaller index >index on iif(CheckStub, "1", "0") + VendCode >* or >index on iif(CheckStub, "T", "F") + VendCode >And a short version of option 1, ergo 1b:
index on TRANSFORM(CheckStub, "Y") + VendCodeThe 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.