>Is it possible to include a logical field into an index? Or should I change the logical field to a one position character field?
>
>Thanks,
>Paul

Convert the logical to character with the IIF() function:

index on ... + iif(MyTable.LogicalField, 'T', 'F') tag mytag