What's the best way to combine a logical and a character field
in an index?

I came up with "iif(table.lfield,'T','F')+table.cfield".