>>Convert the logical to character with the IIF() function:
>>
>>index on ... + iif(MyTable.LogicalField, 'T', 'F') tag mytag
>
>
>Duhh....I should have figured that one out...Someday I will have this language mastered :-)
>
>Thanks,
>Paul
Or to have Trues before falses,
iif(MyTable.LogicalField, '0', '1') tag mytag
Erik Moore
Clientelligence
