>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".
In VFP 6.0 you can use transform function too.
BTW, today once again I found bug in transform for numeric. Is it fixed in VFP7.0?
If it's not broken, fix it until it is.
My Blog 
