>>Hey, I'm exposing myself to being even less of a FoxPro^H^H^HBase guy than I think...
>>
>>Select area: 1, Database in Use: C:\DBASE\IBM.DBF Alias: IBM
>>
>>Master index file: C:\DBASE\CNAME.IDX Key: UPPER(CNAME)+UPPER(LNAME)+UPPER (ADDR)
>>
>>Index file: C:\DBASE\LNAME.IDX Key: UPPER(LNAME)+UPPER(FNAME)+UPPER(ADDR)
>>
>>
>>Index file: C:\DBASE\ADDR.IDX Key: UPPER(ADDR)+UPPER(LNAME)
>>
>>Index file: C:\DBASE\EXPIRE.IDX Key: RIGHT(DTOC(EXPIRE),2)+LEFT(DTO
>>C(EXPIRE),5)+RIGHT(DTOC(NEW),2)+LEFT(DTOC(NEW),5)+UPPER(LNAME)
If this is run under Visual FoxPro, then you should use Rushmore. Here, you are using a series of IDX instead of one CDX. You will never be able to be Rushmore optimizable with that.
As for the tag, I would not suggest that. You may create the tag like EXPIRE or DTOS(EXPIRE). By that, you won't have any trouble with the century stuff. The tag should be created on the field on not on some parts of it.