>Greetings all,
>I am attempting to use a logical field name checkStub (.f., or .t.) in a compound index. The code requires the field to remain a logical fields: .f. or .t. I would like to sort in a compound index with a character field named vendCode. I tried:
>

> str(checkStub) + vendCode
>

>but that gives me "invalid type".
>
>Any ideas?
>
>thanks, vince

To combine several fields, you must normally convert everything to character type.

Here are two alternatives:

* 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