>I want to create an index on 2 fields, one is a character field and one is a logical field. I was thinking about this:
>
>INDEX ON Groupname + TRANSFORM(lgroup,"Y") tag Grouping
>
>Is there a better way to do this (or a reason I shouldn't)?

Michael,
Compound indexes are not optimizable by Rushmore so you could be taking a performance risk by doing this. I would recommend just using the name and using a view to retrieve the data and order it by groupname and lgroup.

Is there another reason to add the logical expression besides sorting?