>Fabio,
>I tried Your suggestion I have a question :o)))))
>
>

>SELECT Hon
>INDEX ON DTOS(DataVed)+BINTOC(Lev1)+BINTOC(Lev2)+BINTOC(Lev3) TAG HonVed
>m2 = DATE(2004,12,2)
>SYS(3054,11)
>SELECT hon.egn, dataved, lev1, lev2, lev3  FROM hon WHERE DTOS(DataVed)+BINTOC(lev1)+BINTOC(lev2)+BINTOC(lev3) LIKE DTOS(m2)+BINTOC(3)+BINTOC(334)+BINTOC(1) NOFILTER
>** Here what SYS(3054) display
>Using index tag Honvedom to rushmore optimize table hon
>Rushmore optimization level for table hon: partial
>Rushmore optimization level for table homo: none
>Joining table hon and table homo using index tag Homo_egn
>

>
>My question is WHY Rushmore optimization level for table hon: partial Partial?
>
>TIA


Borislav,

I would not mix LIKE and bintoc()

LIKE: % for any string and _ underscore for any char

bintoc(37) contains a % sign. Other combinations will likely contain % or _