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
SEEK(' 12345')will work. You can seek just for the first part of the index key. However, I suspect that you are not matching the first part of the key. Display you key for the record ie. field1 and display the string you are using to search ie. ' 12345'.