>My table structure is code c(8),cdate d(10),type c(1)...)
>
>my index key is type+code+dtos(cdate)
>
>Is it possible to use this index only seek for first two charactor are match
>for example: type = 1,code = K0008,Cdate = 01/02/2001, sometime i will seek index for whole string but occasionaly I use it to seek only the first two character. Is that possible to use this index to seek instead of create another index to seek....
>
>Sorry for my english. coding will be appreciated and thanks.
In your example..
If you wanted to seek for all the records with a type of 1 and a code starting with K
=Seek("1K")
As long as Set Exact is off this will work fine
HTH
Will Jones