Where have you SET EXACT OFF and where is this code? SET EXACT is scoped to the datasession, so if you SET EXACT OFF in your main program, but have this code in a form with a private datasession, the setting is not in effect.
>Hi To All,
>
>i have a table tbl_x with an index field1 + field2 TAG ifield
>
>field1 = ' 12345'
>field2 = 'AA'
>
>i tried to used seek' 12345' no records found, but
>seek' 12345AA' it works good.
>
>what can i do seek' 12345'only ?
>i set EXACT OFF and NEAR ON
>
>pls help,
>
>TIA.