Yep, the Rushmore optimizer likes this one! try this:

close table all
clear

create table test ( ctest c(20), cfld1 c(10) )

insert into test (ctest, cfld1) values ('abcdefg', 't1')
insert into test (ctest, cfld1) values ('bbcdefg', 't1')
insert into test (ctest, cfld1) values ('cbcdefg', 't1')
insert into test (ctest, cfld1) values ('aacdefg', 't1')
insert into test (ctest, cfld1) values ('agbcdefg', 't1')

index on mkup() tag Tagtest

sys(3054,1)

select test
select ctest from test where mkup() = 'A' into cursor curtest

brow

sys(3054,0)
close table all

delete file test.dbf
delete file test.cdx

function mkup
return upper(ctest)





>>If I index a file on a function like
>>
>>index on SqueezeDesc() tag Xdesc
>>
>>then query optimizations take advantage of the expression ie.
>>
>>select * from xFile where squeezedesc() = 'ABC' (Fully optimized)
>>
>>After I used STD to reindex the table the expression is no longer Rushmore optimized. What is a workaround for this problem?
>
>I did not think that could ever be optimized. What does KEY(n) return? Does it return SqueezeDesc()?