>Hi Gregory,
>
>>That's avoiding the index. And that's what I was doing, ie using (j_ref=0) instead of (bintoc(j_ref) == bintoc(0))
>
>Uses the added index on PadR(bintoc(j_ref), 5) tag PadR2c in a few places and works correctly.
>Check with sys(3054) the SQL-Count after switching to "where Padr(bintoc(j_ref), 5) == m.lcZero".
>
Yes, I missed that, sorry. Still, it's a bit odd, though
>>I'm currently testing Cetin's suggestion and I think, although not confirmed yet, that it solves the problem
>I hadn't known about a placement issue. Just be sure to permutate some calls to reindex into your tests <g>.
>Index in "my" solution is slightly longer, but I usually don't trust things working after only reordering code sequences.
>
>regards
>
>thomas
thanks for the interest
Gregory